View Single Post
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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