(Msg. 1) Posted: Tue Mar 25, 2008 8:56 am
Post subject: Calculating Hours and minutes Archived from groups: microsoft>public>excel>newusers (more info?)

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.

(Msg. 2) Posted: Tue Mar 25, 2008 9:22 am
Post subject: RE: Calculating Hours and minutes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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

(Msg. 3) Posted: Tue Mar 25, 2008 9:36 am
Post subject: RE: Calculating Hours and minutes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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

(Msg. 4) Posted: Tue Mar 25, 2008 10:00 am
Post subject: RE: Calculating Hours and minutes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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

(Msg. 5) Posted: Tue Mar 25, 2008 11:03 am
Post subject: RE: Calculating Hours and minutes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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

(Msg. 6) Posted: Tue Mar 25, 2008 11:49 am
Post subject: RE: Calculating Hours and minutes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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

You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum