Calcualte date and time
If your beginning time is in A1, and ending time in A2, the formula is:
=a2-a1
Format as a time.
Regards,
Fred
"Chi" wrote in message
...
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
|