Timesheet formula

[markdsmith]

I am using this formula which works great from from within the 24 hour time, but if I go from one day to the next it is off. =SUM((H1543-G1543)*24)

How can I enter a time of 9pm to 2am = 5 and still maintain the normal 6am to 3pm = 9?

 

[ranman256]

Use full date/time in a cell
7/24/2018 4:10 pm

then the math works.

 

[morningstar1001]

Or you can use the if condition to add 1 day (assumption that your time always < 24 hours)

=if(H5-G5 < 0, (h5-g5+1)*24, (h5-g5)*24)

 

[markdsmith]

The hours will always be under 24 hours, but when I do it this way when going from pm to am I get the value of 19 and if I go from am to pm I will get a negative number. Is it that I have to format the cell with a different time option?

 

[markdsmith]

Nevermind, I read what you said wrong. That formula is exactly what I am looking for . Thanks!