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

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

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