A
Angel
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.
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.