Im using
A9 = A10 - (5/1440) copied up to create the 5 minute time difference between rows
A10=FLOOR(NOW(),5/1440) to create the interval that only updates every 5 minutes
but how does one calculate the time difference, maybe as a percentage, between A10=FLOOR(NOW(),5/1440) and =NOW()
Thanks
For instance, now is 13:34
% of change is:
=(NOW()-FLOOR(NOW(),5/1440))/NOW()
=(13:34-13:30)/13:30
=0.000007732%
Does it are you looking for?
Quang PT
Hi, shouldnt 4 minutes into a 30 minute interval have remaining time = 86.67%?
I can calculate the time difference between 2 times in minutes/seconds/milliseconds but thats as far as I got.
=TEXT(B48-B47,"mm:ss:s")
Last edited by prudential; 04-20-2018 at 05:00 AM.
So you want to calculate percentage of remain minutes to next interval of 5 minutes?
NOW() is 15:21
next interval of 5 minutes: =CEILING(NOW(),5/1440)= 15:25
The remaining should be (4 mins/5 mins):
=(15:25-15:21)*1440/5 = 80%
=(CEILING(NOW(),5/1440)-NOW())*1440/5
Is it you are looking for?
Genuis!...Thats exactly what I need. Thank you
Hi, for some reason it doesnt work with large time intervals like 1000 minutes. Do you know why?
Thread has been solved. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks