Brent
asked on
Time: Midnight messing up my totals
I have just about got this thing whipped, but ran into an issue.
The main sheet totals from the other 5 sheets (1st day, 2nd day, ect...).
In each sheet (log) that keeps track of time in the F column, if I enter midnight (00:00)
it then makes my total in G column a zero. If I enter 23:59 or 00:01 it works just fine.
I think a bit of fine tuning of my formula should do the trick, but not sure. I am stuck.
Thanks for any help.
Brent
expert-exchange.xlsx
The main sheet totals from the other 5 sheets (1st day, 2nd day, ect...).
In each sheet (log) that keeps track of time in the F column, if I enter midnight (00:00)
it then makes my total in G column a zero. If I enter 23:59 or 00:01 it works just fine.
I think a bit of fine tuning of my formula should do the trick, but not sure. I am stuck.
Thanks for any help.
Brent
expert-exchange.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Your worksheet is protected. If you're going to post a file for us to look at and work with, please strip your passwords so we don't have to. Kind of hard to give you a good diagnosis without being able to see all of your data.
ASKER
Opps, sorry about that (password).
Roberto, yes, that worked. I am a bit confused, since i think of midnight as 00:00, not 24:00.
But, 00:00 won't work, so I guess I am stuck with 24:00
thanks
Roberto, yes, that worked. I am a bit confused, since i think of midnight as 00:00, not 24:00.
But, 00:00 won't work, so I guess I am stuck with 24:00
thanks
ASKER
Thanks
Hi bvanscoy,
I think of midnight as 24:00 due that first you should reach the 24:00 and then reset to 00:00...
... but when you start counting you star: 1,2,3,4 not 0,1,2,3,4... in this case the first time you could record is 00:01 and so on...
Glad it worked and thaks for the grade,
Roberto.
I think of midnight as 24:00 due that first you should reach the 24:00 and then reset to 00:00...
... but when you start counting you star: 1,2,3,4 not 0,1,2,3,4... in this case the first time you could record is 00:01 and so on...
Glad it worked and thaks for the grade,
Roberto.
The Max should be: 2400
Regards,
R.