View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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!!