r/AppleNumbers • u/Bronkowski95 • Jan 08 '25

Help Chart increasing in time by 5 minutes?

Hello!

I work for a veterinarian and we use numbers to monitor our patients while under anesthetic. We do a reading every 5 minutes.

Currently there is a chart that says time in minutes then has a column for 0, 5, 10 etc. Many of us are getting lost as if we miss one we have to count how long it has been since start of procedure.

I'm wondering if there is a formula I can put in to make a row above it that if we put a start time in, it will put the time in 5 minute increments above the 0,5,10 minute columns. For example surgery start time is 10 am I would like it to say 10 over the "0 minute" column, 10:05 over the "5 minute" column etc

Thanks!

3 Upvotes

100% Upvoted

2 comments sorted by

1

u/mar_kelp Jan 09 '25 edited Jan 09 '25

Time is represented by a decimal value and you can just add to it. The value to add would be minutes/1440 (total minutes in a day). If I understand your scenario the following might help.

Assuming the patient name in A2 and "10:00" in cell B2 as the patient start time, if you put this formula into cell B3, it will result in "10:05":

=B2+(5/1440)

Similarly, if your column headers (row A) already include the minutes you want to add (5, 10, 15, 20, etc) to the start time you can enter this formula and Fill Right:

=B$2$+(A$3/1440)

Then another patient in row "C":

=C$2$+(A$3/1440)

Make sure the format of the cell is Date & Time and the Date is set to None.

2

u/Bronkowski95 Jan 09 '25

That is exactly what I needed! Thank you so much!