Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time difference then rounding down
Hi,
I think what I'm looking for is probably really simple but I just can't seem to get it right! Basically, I currently have an amount of hours in cell F56 (12:00), I want to deduct the times shown in G56 (08:24) and H56 (01:00) and express the outcome as a period of time. Therefore, my formula is currently shown as: =TEXT(F56-G56-H56,"HH:MM") This gives me an outcome of 02:36 - so far so good. I now want to amend the above formula so it still does the same calculation but rounds the total down to the nearest 15 minutes - thus giving an outcome of 02:30. I think this will probably need to include FLOOR somewhere but I can't figure out where/how. Can anybody shed any light on this? Many thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skipping blank cells when calculating time difference | Excel Discussion (Misc queries) | |||
Calculating time difference in minutes | Excel Worksheet Functions | |||
Calculating Time difference based on a condition | Excel Discussion (Misc queries) | |||
Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
Calculating time difference | Excel Discussion (Misc queries) |