| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Day and time difference
I am trying to get the difference between date and time.
Example: Start Date End Date Completed within 12-1-09 8:00 AM 12-3-09 8:30 AM no. of days hh:mm How can i get it to calculate the difference between the no. of days and the time -- Shweta Srivastava |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Day and time difference
Hi,
look into CPearson web http://www.cpearson.com/Excel/DateTimeWS.htm "Shweta Srivastava" wrote: I am trying to get the difference between date and time. Example: Start Date End Date Completed within 12-1-09 8:00 AM 12-3-09 8:30 AM no. of days hh:mm How can i get it to calculate the difference between the no. of days and the time -- Shweta Srivastava |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Day and time difference
=B1-A1 and format the cell as:
d hh:mm:ss -- Gary''s Student - gsnu201001 "Shweta Srivastava" wrote: I am trying to get the difference between date and time. Example: Start Date End Date Completed within 12-1-09 8:00 AM 12-3-09 8:30 AM no. of days hh:mm How can i get it to calculate the difference between the no. of days and the time -- Shweta Srivastava |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between times. Start time: 11:30PM End time: 5 AM | Excel Worksheet Functions | |||
| Time formula (difference of predicted and actual time) | Excel Discussion (Misc queries) | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
![Shweta Srivastava[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
