Sum Time Difference in Quarters between 2 Columns

JamesRiosAUS · 11/09/23

Is there a way to sum the time difference between two columns

There is two columns "Start Time" and "End Time".

If Start Time = 1800 and End Time = 0600, which falls on the next day. I would need it to calculate 12 hours

If Start Time = 1845 and End Time = 0600, which falls on the next day. I would need it to calculate 11.25 hours

Is this possible?

Paul Newcome · 11/09/23

You should be able to find something tucked away in here:

Answers