Time Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What formula do I apply to the following
Start time is 10:00 PM and finish time is 7:00 AM Answer is 9 hour shift
I need the 9 hour shift to read as 9:00 or simply just 9
I have been trying out the TEXT function but my answer is 15??
Thank you for your replies.
 
Try

=MOD(endtime-start_time,1)

or perhaps more pedagogical

=(endtime<start_time)+(endtime-start_time)

start in A1 end in B1

=MOD(B1-A1,1)

or

=(B1<A1)+(B1-A1)
 
Back
Top