| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding the result of two times
Hi everyone, I have a problem I can't seem to solve.....Please help.
I have in cell A23 a date and time ---10/19/2008 14:12---- and in cell A24 a date and time----10/20/2008 16:54--- I need this to calculate the number of hours NOT DAYS and minutes but rond the results to the nearest half hour........See this is calculating the amount of time that a product has been out of cold storage so it can't round the time before calculating.....this is as close as I can come. =TEXT(A24-A23,"[h]:m") this returns...26:42 and I want it to round to read 26.5 thanks. -- Mr.B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING RESULT OF CALCULATION UP OR DOWN | Excel Discussion (Misc queries) | |||
| Rounding Error when Calculating similar times | Excel Worksheet Functions | |||
| Rounding times to the nearest 15 minutes in Excel | Excel Discussion (Misc queries) | |||
| Rounding up the result of an IF function | Excel Worksheet Functions | |||
| Rounding up the result | Excel Worksheet Functions | |||
Threaded Mode
