| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time differences across two (or more) dates
Hello all, What I'm trying to do is to calculate the time difference between two date/times. eg I have 01/05/2006 18:00 in A1 and 02/05/2006 05:30 in B2 How can I calculate the number of hours and minutes that have elapsed between A1 and B2? Currentley I have the cells in dd/mm/yyy hh:mm:ss format but can change this if needs must..... Thanks for yer time! -- jonewer ------------------------------------------------------------------------ jonewer's Profile: http://www.excelforum.com/member.php...o&userid=34332 View this thread: http://www.excelforum.com/showthread...hreadid=540984 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating time differences across two (or more) dates
b2-a1 Format number as a custom format [hh]:mm Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=540984 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Ignore Text when calculating time | Excel Discussion (Misc queries) | |||
| Problem with calculating time | Excel Discussion (Misc queries) | |||
| calculating time | Excel Discussion (Misc queries) | |||
| Calculating effective time from start/end date+time | Excel Worksheet Functions | |||
Linear Mode
