Hello all, So glad I found this incredible forum... Not a newbie to Excel, (been using it since 1990) - just can't figure out how to solve this problem!
On a simple time sheet, I am trying to subtract to time to get the hours, rouded to to the nearest quarter hour. The times entered are generally "pre-rounded" (i.e. entered as 9:15 am, 10:45 pm, etc.)
The problem comes in the type of business I am in often requires strange hours that can overlap a day.
For example, I may start at 8:00 am on Monday, and not finish until 9:00 am the following day.
What type of job would someone take where they have to work a 25 hour day? Glad you asked. I work in concert lighting and video production and believe me, that is a SHORT day!
Anyway, so as you can imagine, subtracting 9:00 am from 8:00 am will not give me the correct answer.
I tried searching the forum, the internet, my mind (which pretty much came up empty). THEN - I found this forum. SOMEWHERE on this forum, there is a guru that can figure this out.
My calculator and myself will be eternally grateful.
Thanks in advance to anyone who can help.
P.S. Sorry I can't get you tickets to a concert for helping. We don't do THOSE types of concerts, unfortunately.