Question about total time formula

Tjmarget

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!

Mathieu PERSICO

Hi Tjmarget,

Try this formula :

=VALUE(([End Date]@row - [Start Date]@row) * 24) + VALUE(LEFT([End Time]@row, 2)) + VALUE(RIGHT([End Time]@row, 2)) / 60 - VALUE(LEFT([Start Time]@row, 2)) - VALUE(RIGHT([Start Time]@row, 2)) / 60

Hope this helps!

Have a good day,

Mathieu | evolytion.com

Tjmarget

Hi Mathieu!

That did the job! Thank you so much for taking the time to help me with this.

Mathieu PERSICO

Great! Glad to help!