View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Calculating time

Subtract one from the other, and format as [h]:mm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Gary H" wrote in message
...
Hi, using Excel 2002 here.

I have 2 cells which are each formatted as "mm/dd/yy hh:mm" . I am trying

to
get the number of hours:minutes between them. Please note that there can

be
several days in between. How can I do this?

Thank you in advance

Gary