| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate the number of hours between two dates and times
I need to calculate the number of hours and minutes between two dates
and the time. For e.g. 23.10.05 10:00 and 25.10.05 10:15. Does anyone knw how to do this. Thanks a lot Princy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate the number of hours between two dates and times
=A2-A1 (If A2 is the largest)
Format Custom as [h]:mm -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ups.com... |I need to calculate the number of hours and minutes between two dates | and the time. | For e.g. 23.10.05 10:00 and 25.10.05 10:15. Does anyone knw how to do | this. | Thanks a lot | | Princy | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate times between dates and times in Excel | Excel Discussion (Misc queries) | |||
| Calculate hours between to separate dates and times | New Users to Excel | |||
| How do I calculate dates and times, w/answer of days & hours | Excel Worksheet Functions | |||
| Calculate hours and minutes between times when it goes past midnig | Excel Worksheet Functions | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
Linear Mode
