Trever,
=(B3-A3)*24-C3*24
Format for General, Number, or anything except Date/Time. Format - Cells -
Number.
You'll get 7.5. If you got 7:50, as you requested, it would look like hours
and minutes.
--
Earl Kiosterud
www.smokeylake.com
"Trever B" wrote in message
...
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