Hi
not being my area of expertise this, wondered if anyone could give me a simple formula for the following:
I have a list of timings [hh]:mm
what I need to do is add 15 minutes for each elapsed hour.
E.g.
A1:07:15
A2:04:45
new time would read
B1:09:00
B2:05:45
In M5 I have 00:15 to act as the trigger for the 15 minutes
I have created this formula which seems to work fine: =SUM(A1+(HOUR(A1)*$M$5))
the next bit I can't seem to work is how to round the number up to the nearest 5 minutes.
any ideas please?
Bookmarks