User Profile
JD1455
Copper Contributor
Joined 10 months ago
User Widgets
Recent Discussions
Formula to remove afterhours and weekends from number
First, let me tell you that I am alright at Excel, but am by no means an expert. I have a formula our users are using, where they now want to remove any time afterhours (outside 8AM-5PM) and weekends. The formula they have is:=TEXT(A1-A2, "[h]:mm:ss") Their example is: A1 A2 A3 02-16-2024 13:05 02-21-2024 08:02 114:57:00 The time in A3 should be 3:57:00 hours, not 114:57:00 hours. (The correct time should be 21:57:00, not 3:57:00). Any help would be greatly appreciated.Solved669Views0likes4Comments
Recent Blog Articles
No content to show