View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default formula to calculate number of hours worked in a day

I was, of course, asleep when I said DIVIDE by 24. I should have said
MULTIPLY by 24.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
If you want to get decimal hours, rather than Excel time format, divide by
24 and format as General or Number.

But the answer is 8 hours, not a sub-zero number. You may need to check
that all your data are times, not text. Temporarily format the four input
cells as number, rather than time, and then you should see them all change
to decimals of a day. If they don't all change to decimals of a day,
there may be spare spaces or non-printing characters which are keeping
them as text.
--
David Biddulph

"xololady" wrote in message
...
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?