# Question about total time formula

Options
✭✭

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!

• Options

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

Mathieu | Workflow Consultant

info@evolytion.com

• ✭✭
Options

Hi Mathieu!

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

• Options