Calculating Time

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

 

[Sandy Mann]

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

 

[Guest]

Thank you very much Sandy!

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

 

[Sandy Mann]

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