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

08:30 in A1
17:15 in B1
=B1-A1 in C1 gives 08:45
If the times might go over midnight, use =B1-A1+(A1B1)
--
David Biddulph

"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!!

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

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

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

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

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

What have you tried exactly ?

Steve

On Thu, 25 Jan 2007 22:01:02 -0000, ng66
wrote:

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