Total Time

[Scooterdog]

What would be the correct formula for counting time up to but not beyond a
certain point?
Example: From 22:00 up to but not past 22:58.
Thank you

 

[Jerry W. Lewis]

Your question is unclear. You can simply add times, but do you want to
stop when the total is 22:58 (and do what then?) or do you want to
exclude from the sum any individual times that exceed 22:58?

Time is stored as a fraction of a day, so 22 hours and 58 minutes is
=22/24+58/24/60 which is 689/720 or 0.956944444444444. You can sum only
smaller times by =SUMIF(range,"<689/720")

Jerry

 

[Scooterdog]

Jerry, I need to exclude from the sum any times that exceed 22:58!
Thanks in advance

 

[Peo Sjoblom]

=SUMIF(A1:A10,"<="&TIME(22,58,0))

if you want to count change it to countif instead