Hey Guys,
Love the site and have referenced it many many times for help with excel. But i cannot seem to find anything to help me and here i am the newest member, and looking for help.
I am trying to make a spreadsheet for work that will calculate hours remaining between two times. I would like to use the =Now () function to bring up the current time of day and i would like that time to be subtracted from the next day @ 09:00. I would like the dates to roll with the current calendar day if possible. Of if not just be able to reference 09:00.
The exact time the next day is crucial. I can't seem to get the coding right, i would consider myself a rookie at excel so this may be a easy win for a expert.
ie
Hours remaining between
July 7th @ 17:00 and July 8th @ 09:00
Thanks in Advance
Bandit
Bookmarks