Excel Calculating Time
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!!
|