View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark McDonough
 
Posts: n/a
Default Time function for timesheeets

What formula can I use to achieve the following result

Start 8.30am
Lunch half an hour
Finish 5.30 pm

Total time = 8.3 is the result required but can't get it to work.

Time involved is 8hours and 30mins.