Hours over 24
 

I need to calculate hours. I have a formula set up for part of my equation
where I'm adding up the total hours that something took place for the month
(by entering each occurance and then summing), but I need to take the total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as the
time?

Hours over 24
 

FormatCells|Number Tab|Custom....Enter

[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of my equation
where I'm adding up the total hours that something took place for the month
(by entering each occurance and then summing), but I need to take the total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as the
time?

Hours over 24
 

Format the cells as hh:mm
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of my equation
where I'm adding up the total hours that something took place for the month
(by entering each occurance and then summing), but I need to take the total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as the
time?

Hours over 24
 

I think you intended to say [hh]:mm ?
--
David Biddulph

"Sheeloo" just remove all As... wrote in
message ...
Format the cells as hh:mm
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of my
equation
where I'm adding up the total hours that something took place for the
month
(by entering each occurance and then summing), but I need to take the
total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as
the
time?

Hours over 24
 

Yes, thanks.
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"David Biddulph" wrote:

I think you intended to say [hh]:mm ?
--
David Biddulph

"Sheeloo" just remove all As... wrote in
message ...
Format the cells as hh:mm
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of my
equation
where I'm adding up the total hours that something took place for the
month
(by entering each occurance and then summing), but I need to take the
total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as
the
time?

Hours over 24
 

try
right click on the cell/s
Format Cells
Select Time
In Type, choose 37:30:55
OK

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of my equation
where I'm adding up the total hours that something took place for the month
(by entering each occurance and then summing), but I need to take the total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as the
time?

Hours over 24
 

This has the number showing up correctly on the spreadsheet, but when I have
the cell highlighted it's still showing up as 1/2/1900 10:07 and using this
when I try and do a calculation with it.

"Jacob Skaria" wrote:

FormatCells|Number Tab|Custom....Enter

[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of my equation
where I'm adding up the total hours that something took place for the month
(by entering each occurance and then summing), but I need to take the total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as the
time?

Hours over 24
 

Its the same thing, XL will still be able to do your calculations.
2.42 = 58:07 = 1/2/1900 10:07 AM

It's the same number no matter how you calculate, all you're changing is how
it is displayed. The math works out the same no matter how you display it.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"dolphin1986" wrote:

This has the number showing up correctly on the spreadsheet, but when I have
the cell highlighted it's still showing up as 1/2/1900 10:07 and using this
when I try and do a calculation with it.

"Jacob Skaria" wrote:

FormatCells|Number Tab|Custom....Enter

[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of my equation
where I'm adding up the total hours that something took place for the month
(by entering each occurance and then summing), but I need to take the total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as the
time?

Hours over 24
 

The math isn't coming out to what I need though. I'm trying to subtract 22
hrs and 41 minutes from 58:07 and it's giving me 11 hrs and 26 minutes. When
it should be 35 hrs and some minutes. I may need to convert everything into
minutes first and then figure out the hours.

"Luke M" wrote:

Its the same thing, XL will still be able to do your calculations.
2.42 = 58:07 = 1/2/1900 10:07 AM

It's the same number no matter how you calculate, all you're changing is how
it is displayed. The math works out the same no matter how you display it.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"dolphin1986" wrote:

This has the number showing up correctly on the spreadsheet, but when I have
the cell highlighted it's still showing up as 1/2/1900 10:07 and using this
when I try and do a calculation with it.

"Jacob Skaria" wrote:

FormatCells|Number Tab|Custom....Enter

[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of my equation
where I'm adding up the total hours that something took place for the month
(by entering each occurance and then summing), but I need to take the total
hours for the month which in one instance is 58 hrs and 7 minutes and
subtract the occurances from that to find out the difference. How can I
enter the 58:07 without it giving me a January 2, 1900 date and 10:07 as the
time?

Hours over 24
 

My guess is that what you are subtracting isn't 22:41 but 46:41.
Remember to format all the relevant cells as [h]:mm, not as h:mm
--
David Biddulph

dolphin1986 wrote:
The math isn't coming out to what I need though. I'm trying to
subtract 22 hrs and 41 minutes from 58:07 and it's giving me 11 hrs
and 26 minutes. When it should be 35 hrs and some minutes. I may
need to convert everything into minutes first and then figure out the
hours.

"Luke M" wrote:

Its the same thing, XL will still be able to do your calculations.
2.42 = 58:07 = 1/2/1900 10:07 AM

It's the same number no matter how you calculate, all you're
changing is how it is displayed. The math works out the same no
matter how you display it. --
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"dolphin1986" wrote:

This has the number showing up correctly on the spreadsheet, but
when I have the cell highlighted it's still showing up as 1/2/1900
10:07 and using this when I try and do a calculation with it.

"Jacob Skaria" wrote:

FormatCells|Number Tab|Custom....Enter

[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"dolphin1986" wrote:

I need to calculate hours. I have a formula set up for part of
my equation where I'm adding up the total hours that something
took place for the month (by entering each occurance and then
summing), but I need to take the total hours for the month which
in one instance is 58 hrs and 7 minutes and subtract the
occurances from that to find out the difference. How can I enter
the 58:07 without it giving me a January 2, 1900 date and 10:07
as the time?