View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
xololady xololady is offline
external usenet poster
 
Posts: 9
Default formula to calculate number of hours worked in a day

I am trying to put together a time sheet, where I can put my time in and out,
and then give the total hours at the end of the day. For example, I sum (12
pm -8 am) + (5 pm -1 pm). I have formatted these cells to show time. But my
formula spits out a sub zero number. Do I need to divide these by 24?