View Single Post
  #2   Report Post  
Kevin Lehrbass
 
Posts: n/a
Default Excel time formula

Hi Dewey,

If 4:00 pm is in cell A1 and 5:15 pm is in cell A2, then in cell A3 put =A2-A1
Also, in cell A3, you must go to Format Cells, number tab, custom and enter
"[h]:mm".

If you have any questions, don't hesitate to send me an email.

Have a great weekend,
--
Kevin Lehrbass
www.spreadsheetsolutions4u.com


"Dewey" wrote:

Is there a formula that can calculate the difference between two hour/minute
entries, such as converting the time between 4:00 and 5:15 is 1:25.
--
Dewey