I always prefered to have people entering time in 24 hour format because it
is too easy for inexperienced operators to enter 8:15PM instead of 8:15 PM
and end up with #VALUE! errors. In fact the resulting time *has* to be
formatted as hh:mm otherwise you will get an elapsed time of, say, 2:15 AM.

--
HTH

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


with @tiscali.co.uk


"ng66" wrote in message
...
Perfect, thanks!

"David Biddulph" wrote:

8:15 PM will work equally well, if you prefer.
--
David Biddulph

"ng66" wrote in message
...
So it has to be done in military time, ie 20:15??

"Sandy Mann" wrote:

With times entered as XL time (ie like 8:45 with a full colon)

Start time in B2
End time in C2

Hours in D2:

=C2-B2
and format the cell as custom hh:mm

If you SUM() the hours worked the custom format the cell as [hh]:mm
which will stop the hours rolling over into days when they reach 24

--
HTH

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


with @tiscali.co.uk


"ng66" wrote in message
...
Can Excel calculate daily hours with just a cell that contains a
start
time
and one that contains an end time? I tried different things but they
all
came
out with ###VALUE or ###REF and junk like that...

THANKS YET AGAIN!!