Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default calculate time in days:hours:minutes

I am trying to get Excel to calculate an elapsed time in simple terms, i.e.
dd:hh:mm. For example: the total elapsed time between 01/01/07 at 0200
(start time) and 02/05/07 at 1530 (stop time)

I would like it to display as 35:13:30 (dd:hh:mm)

I can't seem to get Excel to count past 31 days...it calcualtes correctly up
to the 31 day and then starts over. In the above example, my formula
calculates it as 4:13:30
--
.....Stice
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default calculate time in days:hours:minutes

=(DAYS360(C1,C2)+1)&":"&HOUR(C2-C1)&":"&MINUTE(C2-C1)

"Stice" wrote:

I am trying to get Excel to calculate an elapsed time in simple terms, i.e.
dd:hh:mm. For example: the total elapsed time between 01/01/07 at 0200
(start time) and 02/05/07 at 1530 (stop time)

I would like it to display as 35:13:30 (dd:hh:mm)

I can't seem to get Excel to count past 31 days...it calcualtes correctly up
to the 31 day and then starts over. In the above example, my formula
calculates it as 4:13:30
--
....Stice

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF statement to calculate time usage in specific time bands Daren Excel Worksheet Functions 6 January 31st 07 02:34 PM
Create a function to calculate Mean time Before Failure RMC Excel Worksheet Functions 0 November 3rd 06 02:34 AM
Calculate time within time Frigid Excel Worksheet Functions 2 October 25th 06 12:52 AM
HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL RAFAEL New Users to Excel 1 June 26th 05 11:32 PM
Calculate time Rao Ratan Singh Excel Discussion (Misc queries) 2 March 17th 05 03:28 PM


All times are GMT +1. The time now is 11:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"