Thread
:
Calculating Time
View Single Post
#
3
Posted to microsoft.public.excel.misc
Secret Squirrel
external usenet poster
Posts: 172
Calculating Time
Thank you very much Sandy!
"Sandy Mann" wrote:
Secret Squirrel"
For times that do or could cross midnight use:
=Mod(C2-B2,1)
or
=C2-B2+(C2<B2)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Secret Squirrel" wrote in
message ...
I have a spreadsheet with 2 columns. The first column is the start time and
the second is the end time. They are shown in military time. I want to
calculate the difference between the two so I can get hours worked but
when
the time overlaps days I get no result. For example if a worker started at
16:00 (4:00pm) and ended at 01:18 (1:18am) I get no result. Why is that?
It
seems to work on calculations that do not overlap into the next day.
Reply With Quote
Secret Squirrel
View Public Profile
Find all posts by Secret Squirrel