LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Calculating number of hours and minutes

Please can someone tell me how to calculate the number of hours and minutes
between two times, where the two times span more than 24 hours?

For example, if the starting date/time is 24 Dec 13:00 and the ending time
is 27 Dec 13:30, then the number of hours and minutes lapsed is 72 hours 30
minutes.
 
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
wages - multiply hours and minutes by number of hours worked Carol (Australia) Excel Discussion (Misc queries) 6 April 1st 07 01:16 AM
Calculating time, hours and minutes arrowpilot Excel Discussion (Misc queries) 1 October 21st 06 12:04 AM
calculating fees from hours and minutes tinytots Excel Worksheet Functions 2 November 19th 05 05:29 PM
how to change a decimal number (minutes) into hours and minutes? Erwin Excel Discussion (Misc queries) 2 November 5th 05 04:22 PM
How do I convert a number of minutes into hours and minutes? gyrkin Excel Worksheet Functions 3 August 18th 05 11:12 PM


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

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

About Us

"It's about Microsoft Excel"