Thread: Difference between date and time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default Difference between date and time
=B1-A1
Format the cell with custom format [h]:mm to see 2:30 or 24:30, or with
[hh]:mm to see 02:30 or 24:30
The [ ] are needed to get Excel to display more that 24 hours
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Joshua" wrote in message
...
I am trying to get the difference between date and time into the hh:mm
format.
Example:

Start Date End Date Time taken to complete
7-1-09 8:00 AM 7-2-09 8:30 AM 24:30

How can i get it to calculate the difference between the date and the time


Reply With QuoteReply With Quote