Calcualte date and time

C

Chi

Hi

Please help me how to calculate the number of hours and minutes
Between two columns:

Ex:
Beginning Apt. Ending Apt.
2/1/10 9:40am and 2/1/10 2:00pm. It will be 4 hours and 20 minutes or
(4:20) if I calculate manually. Please help me to write the formula.

Thanks
Chi
 
F

Fred Smith

If your beginning time is in A1, and ending time in A2, the formula is:
=a2-a1

Format as a time.

Regards,
Fred
 
F

FSt1

hi
simply subtract the earier time from the later time.
if 2/1/10 9:40am was in A2 and 2/1/10 2:00pm was in B2

=B2-A2

format as [h]:mm or [h]:mm:ss

Regards
FSt1
 
C

Chi

Thank you very much!

FSt1 said:
hi
simply subtract the earier time from the later time.
if 2/1/10 9:40am was in A2 and 2/1/10 2:00pm was in B2

=B2-A2

format as [h]:mm or [h]:mm:ss

Regards
FSt1

Chi said:
Hi

Please help me how to calculate the number of hours and minutes
Between two columns:

Ex:
Beginning Apt. Ending Apt.
2/1/10 9:40am and 2/1/10 2:00pm. It will be 4 hours and 20 minutes or
(4:20) if I calculate manually. Please help me to write the formula.

Thanks
Chi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top