Calculating Hours and minutes

actually i am trying to count hours by adding an amount to my total every 7
days. it started at 0 and is now 200hrs and 30 mins. i want to add how long
it was used onto this total every week.
It wont let me calculate over say 1000hours

"Mike H" wrote:

> Hi,
>
> =B1-A1
> format as [hh]:mm
>
> earlier date and time In A1
>
> Mike
>
> "Nick" wrote:
>
> > I am needing to calculate how long an item was used for using hours and
> > minutes.
> > Is there a formula or format that will let me do this.
> > The total will go into thousands of hours.
> > And i cannot have days or seconds, must only be hours and minutes in my
> > spreadsheet.
> >
> > Can anyone help

There's no need for another thread, If someone knows the answer you'll get it
in the first one.
> It wont let me calculate over say 1000hours
What does this mean with cells formatted as [hh]:mm I can add up hours in
excess of 1000. What formula are you using?

As an example all formatted as [hh]:mm

a1=1100:58
b1=900:24
c1=A1+b1 gives an answer of 2001:22

Mike


"Nick" wrote:

> actually i am trying to count hours by adding an amount to my total every 7
> days. it started at 0 and is now 200hrs and 30 mins. i want to add how long
> it was used onto this total every week.
> It wont let me calculate over say 1000hours
>
> "Mike H" wrote:
>
> > Hi,
> >
> > =B1-A1
> > format as [hh]:mm
> >
> > earlier date and time In A1
> >
> > Mike
> >
> > "Nick" wrote:
> >
> > > I am needing to calculate how long an item was used for using hours and
> > > minutes.
> > > Is there a formula or format that will let me do this.
> > > The total will go into thousands of hours.
> > > And i cannot have days or seconds, must only be hours and minutes in my
> > > spreadsheet.
> > >
> > > Can anyone help

sry i meant 10,000:00
this is what i have
time ran total time ran
A B
1 9975:30
2 57:60 00:00 - this is what it calculates to!

it wont let me calculate over 4 figures in hrs and returns the value to zero.
i am using format [hh]:mm and formula is =SUM(B1,A2)

"Mike H" wrote:

> There's no need for another thread, If someone knows the answer you'll get it
> in the first one.
> > It wont let me calculate over say 1000hours
> What does this mean with cells formatted as [hh]:mm I can add up hours in
> excess of 1000. What formula are you using?
>
> As an example all formatted as [hh]:mm
>
> a1=1100:58
> b1=900:24
> c1=A1+b1 gives an answer of 2001:22
>
> Mike
>
>
> "Nick" wrote:
>
> > actually i am trying to count hours by adding an amount to my total every 7
> > days. it started at 0 and is now 200hrs and 30 mins. i want to add how long
> > it was used onto this total every week.
> > It wont let me calculate over say 1000hours
> >
> > "Mike H" wrote:
> >
> > > Hi,
> > >
> > > =B1-A1
> > > format as [hh]:mm
> > >
> > > earlier date and time In A1
> > >
> > > Mike
> > >
> > > "Nick" wrote:
> > >
> > > > I am needing to calculate how long an item was used for using hours and
> > > > minutes.
> > > > Is there a formula or format that will let me do this.
> > > > The total will go into thousands of hours.
> > > > And i cannot have days or seconds, must only be hours and minutes in my
> > > > spreadsheet.
> > > >
> > > > Can anyone help

Nick,

Now I understand you've encountered this
http://support.microsoft.com/kb/214386

However, I still don't see your problem because all this means is you cant
enter 10000 hours in a cell but you can sum 2 cells to a total in excess of
that

Mike

"Nick" wrote:

> sry i meant 10,000:00
> this is what i have
> time ran total time ran
> A B
> 1 9975:30
> 2 57:60 00:00 - this is what it calculates to!
>
> it wont let me calculate over 4 figures in hrs and returns the value to zero.
> i am using format [hh]:mm and formula is =SUM(B1,A2)
>
> "Mike H" wrote:
>
> > There's no need for another thread, If someone knows the answer you'll get it
> > in the first one.
> > > It wont let me calculate over say 1000hours
> > What does this mean with cells formatted as [hh]:mm I can add up hours in
> > excess of 1000. What formula are you using?
> >
> > As an example all formatted as [hh]:mm
> >
> > a1=1100:58
> > b1=900:24
> > c1=A1+b1 gives an answer of 2001:22
> >
> > Mike
> >
> >
> > "Nick" wrote:
> >
> > > actually i am trying to count hours by adding an amount to my total every 7
> > > days. it started at 0 and is now 200hrs and 30 mins. i want to add how long
> > > it was used onto this total every week.
> > > It wont let me calculate over say 1000hours
> > >
> > > "Mike H" wrote:
> > >
> > > > Hi,
> > > >
> > > > =B1-A1
> > > > format as [hh]:mm
> > > >
> > > > earlier date and time In A1
> > > >
> > > > Mike
> > > >
> > > > "Nick" wrote:
> > > >
> > > > > I am needing to calculate how long an item was used for using hours and
> > > > > minutes.
> > > > > Is there a formula or format that will let me do this.
> > > > > The total will go into thousands of hours.
> > > > > And i cannot have days or seconds, must only be hours and minutes in my
> > > > > spreadsheet.
> > > > >
> > > > > Can anyone help