HI Jules
First your number should be real time formatted as HH:MM, your showing 17:00
pm. 17:00 should'nt have any pm.
A1 has starting time 17:00
B1 has 02:00
C1 =MOD(B1-A1,1)Format Custom[h]:mm
HTH
John
"Jules" wrote in message
...
I am trying to set up a roster/time sheet that will give me my expected
gross
wages for the week. I am having trouble because staff are finishing at 1am
or
2am and i'm not sure how to calculate the hours worked using a formula. I
am
just getting #### because it is a negative number. eg 17:00pm - 1.00am.
Thank you in advance