Thread
:
How to set a time for the next 1/4 hour
View Single Post
#
6
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 1,071
How to set a time for the next 1/4 hour
Nitpicking comment: I realize that 96 is the inverse of how XL stores
a time of 15 minutes (0:15:00), but an identical formulation that makes
the intent somewhat more evident is:
--
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
Bruce,
This should get you started
MsgBox Format(Application.RoundUp(Time * 96, 0) / 96, "hh:mm:ss")
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"BruceJ" wrote in message
news:%Henb.32171$275.58288@attbi_s53...
I am looking to find out how to set a timer to the next 15 min interval
(On
the 1/4 hour)
What would be the best way to set a varible (NxtTime) to the next 1/4
hour?
I need to have something run at each 15 minutes on the quater hour, how
can
I figure out the NEXT 1/4 hour? I know I will add 900 seconds after that,
but I am not sure how to figure out the next 1/4 hour....
Thanks
Bruce
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta