|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 10th, 2010, 03:37 PM
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
February 10th, 2010, 04:20 PM
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
February 10th, 2010, 04:28 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
