Calculating Hours and minutes

[Nick]

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

 

[Mike H]

Hi,

=B1-A1
format as [hh]:mm

earlier date and time In A1

Mike

 

[Nick]

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

Hi,

=B1-A1
format as [hh]:mm

earlier date and time In A1

Mike

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

 

[Mike H]

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

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

Hi,

=B1-A1
format as [hh]:mm

earlier date and time In A1

Mike

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]

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)

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

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

Hi,

=B1-A1
format as [hh]:mm

earlier date and time In A1

Mike

:

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

 

[Mike H]

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

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)

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

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

:

Hi,

=B1-A1
format as [hh]:mm

earlier date and time In A1

Mike

:

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