Hour manipulation

[Redwings]

i have a file download that shows hours worked for employees in th
following format 72:09:50(hh:mm:ss). The problem is this, the data i
displayed in that format but in the formula bar it shows the data a
1/3/1900 12:09:50 AM. Because of this, I can not manipulate the data
How can I, in essence, make the data a string or some state in whic
it is not recognized as a date and time. I have tried copying the dat
and pasting it as a value, one hundred different formatting tries, an
everything else I can think of. pls hl

 

[DDM]

Redwings, this will turn a time entered in Cell A1 into a string:
=TEXT(A1,"[h]:mm:ss")

 

[David McRitchie]

Hi Redwings,
To keep the hours from overflowing into days use
[h]:mm:ss

If you want to multiply by an hourly rate for wages,
you will have to multiply your time by 24 to convert
days to hours, as time is a measured in days in Excel.

More on Date and TIme on my page
http://www.mvps.org/dmcritchie/excel/datetime.htm

 

[David McRitchie]

Correct formatting but that requires two columns,
one for the arithmetic amount and one for display,
when all that is needed is to format the
time with a number format.

Redwings, this will turn a time entered in Cell A1 into a string:
=TEXT(A1,"[h]:mm:ss")

=