Day and time difference

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

=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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Difference between Windows Time Service and Internet Time in Date & Time Properties	Saucer Man	Windows XP General	0	14th Feb 2008 01:51 PM
subtract the time difference from another time difference	=?Utf-8?B?RGFubmlnaXJs?=	Microsoft Excel Misc	3	30th Sep 2007 03:47 PM
Comparing 2 files on date/time stamp, and based time difference do a subroutine	info@stevik.nl	Microsoft Excel Programming	1	28th Sep 2007 03:53 AM
How can I find records based upon a date and time range while accounting for time zone difference	BJC	Microsoft Access	2	11th Jul 2007 01:13 AM
Time difference error with no time difference	Rob Oldfield	Microsoft Windows 2000 Security	0	5th Mar 2004 10:33 AM