Calculating hours worked for a night shift

[mzegers]

Hello,

I am trying to create a formula to calculate hours worked (clock in/clock out). The shift that worked is from 5pm-1am or whenever the work is done.

I can calculate hours for a shift worked in the same day (8am-5pm) but not one that is worked from the night before to the next morning. Can someone help me?

Thanks

 

[meguilbert]

Try formating your cells with the Date as MM/DD/YY Time. To do this highlight cells [Format], [Number], [Date], Select the type. There are two with date and time, on standard and one military.

HTH,

 

[barry houdini]

If you have start time in A2 and end time in B2 then this formula will give the hours worked, whether passing midnight or not

=B2-A2+(A2>B2)