Hello
I have searched forums today to no avail. I am very inexperienced with Excel and feel like this might be quite a simple question!
This is what I want to do:
A1 - initial start time [8:00 AM]
B1 - end time [8:05 AM]
C1 - rounded up to number of six minute units indicated as a decimal [0.1] formula =ROUNDUP(HOUR(B1-A1)+DOLLARDE(MINUTE(B1-A1)/60,10),1)
D1 - indicated as minutes [.06] formula =C1*0.6
I have the above working ok so far. What I want to do is then have a formula so that A2 is however many 'units' (i.e. six minute increments) later than A1. So, I need the formulas to automate A2, A3 and so on, in the following example:
Excel query.jpg
Please help!!
Thank you.
Bookmarks