Total Time

  • Thread starter Thread starter Scooterdog
  • Start date Start date
S

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
 
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
 
Jerry, I need to exclude from the sum any times that exceed 22:58!
Thanks in advance
 
=SUMIF(A1:A10,"<="&TIME(22,58,0))

if you want to count change it to countif instead
 
Back
Top