View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
[email protected] google@inbox.com is offline
external usenet poster
 
Posts: 1
Default Calculating Time Elapsed in Excel

Hi Everyone,

How can I calculate the time elapsed between two given times?
For example if I input initial time and date as 20:00 on 03 Jan 06 and
final time and date as 05:00 on 05 Jan 06, I want to calculate the
number of hours elapsed. Moreover I am interested in whole numbers i.e.
8 hours and 31 minutes should round to 9 hours and 8 hours and 29
minutes should round to 8 hours. I need to multiply this time elapsed
with another constant quantity?

Any help would be appreciated.

regards