View Single Post
  #1   Report Post  
Trever B
 
Posts: n/a
Default Time differances

1 have 4 boxes

start time end time lunch hours worked
09:00 17:00 1.00 7:00
09:00 17:00 0.30 7:70 (should
be 7:50)

(B3-A3)*24-C3

How do I make it 9.5 hours by changing forumla

Thanks