View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default 24 hour clock formula for elapsed time between 1215 and 1630

With 16:30 in A1 and 12:15 in B1, put this in C1
=A1-B1
to get the difference 4:15

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Tader" wrote:

I would expect to see something like either 4.25 or 4:15 or ??