ExcelBanter - Day and time difference

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Day and time difference (https://www.excelbanter.com/new-users-excel/255925-day-time-difference.html)

Shweta Srivastava[_2_]

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

Eduardo

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

Gary''s Student

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

All times are GMT +1. The time now is 09:39 PM.