Calculating Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Thank you very much Sandy!

Sandy Mann said:
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Your're very welcome

--
Rgards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top