Thread: Calculate the difference in date/time formatted cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
  
Posts: 1,533
Default Calculate the difference in date/time formatted cells
Just subtract the two cells and format the formula cell as custom [h]: mm

=A2-A1

Regards,
Per

"Longhorn1972" skrev i meddelelsen
...
I need to know how to find the difference in time in two cells with a
date/time format of 05/01 04:30

Reply With QuoteReply With Quote