Timesheet - Total time

[itsgrady]

I have a form (a timesheet) that I need to find the difference between two times--a start time and an end time. These two times can be a max of 16 hours and can be over two different days. The total needs to be a number like 11.5 for 11 hours and 30 minutes of work.

The biggest problem is only have one date. For an example: On 11/01/22 the person worked from 6:00PM to 6:00AM the next day for a total of 12 hours. I need to be able to type:

1 Date: 11/02/22
Start Time: 6:00 PM
End Time: 6:00 AM
Total: Need the calculation in a number - 12

 

[AhoyNC]

Try:

Book1
	A	B
1	Date	11/2/2022
2	Start	6:00 PM
3	End	5:30 AM
4		11.5
Sheet3

Cell Formulas
Range	Formula
B4	B4	=MOD(B3-B2,1)*24

 

[itsgrady]

Try:

Book1
	A	B
1	Date	11/2/2022
2	Start	6:00 PM
3	End	5:30 AM
4		11.5
Sheet3

Cell Formulas
Range	Formula
B4	B4	=MOD(B3-B2,1)*24

Thanks for taking time to give a very clear answer—very helpful.