Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating the time between one date and another
Hi there. I have a worksheet with four cells in it:
Start Date Start Time End Date End Time. I need to calculate in hours the diffrence between the two. I am using Excel 2000 and unfortunately the cells have to remain seperate. Can anyone please help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating the time between one date and another
Samwar
With the entries in A1:A4 (Later date/time in A3 and A4) then in A5 enter =(A3+A4)-(A1+A2) and format the result as (FormatCells...NumberCustom) [hh]:mm the square brackets stop hours over 24 from incrementing to days -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Samwar" wrote in message ... Hi there. I have a worksheet with four cells in it: Start Date Start Time End Date End Time. I need to calculate in hours the diffrence between the two. I am using Excel 2000 and unfortunately the cells have to remain seperate. Can anyone please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|