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
bvanscoy678Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
PabilioConnect With a Mentor Commented:
Hi Bvanscoy...

Try changing your validation limits from:

Min: 0
Max: 2359

to:

Min: 1
Max: 24:00

Hope it helps,
Roberto.
0
 
PabilioCommented:
Typo:
The Max should be: 2400

Regards,
R.
0
 
Zack BarresseCEOCommented:
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.
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
bvanscoy678Author Commented:
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
0
 
bvanscoy678Author Commented:
Thanks
0
 
PabilioCommented:
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.
0
All Courses

From novice to tech pro — start learning today.