Question about total time formula
Good Afternoon! I am successfully using the following formula to calculate total time from a start and end date and time:
=((VALUE(LEFT([End Time]@row, FIND(":", [End Time]@row) - 1)) + VALUE(RIGHT([End Time]@row, 2)) / 60) + ([End Date]@row - [Start Date]@row) * 24) - (VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) + VALUE(RIGHT([Start Time]@row, 2)) / 60)
The guys using the sheet want me to take the : out of the time and change to an all numbers format (0600 vs. 06:00). I don't want to mess up my formula. Any ideas on how to make that change and still have the formula calculate total time? Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!