Calculating Hours

N

Nick

I am looking to calculate hours and minutes.
I want to calculate how long something has been running for by adding hours
and minutes every week to the total.
The problem is it stops counting after about 1000hours. is there a formula
to count hours and minutes up to say 10000hours.
 
B

Bernard Liengme

It I put 500:45:00 in a1
and &00:45:25 in A1
The in A3 =A1+A2, I get 1201:30:25

I do not understand "it stops counting after 1000 hours" please give more
details of your worksheet's layout
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Hours and minutes 5
Hours Calculations 9
How to add hours and minutes? 5
Total Hours 7
Calculating hours on a timeclock form 7
Complete Novice! Require help with "simple" Excel doc 0
Formula and field types for calculating times 3
Calculate hour and minutes worked each day 3

Top