You're sure making it difficult for people to provide help.
First you say you have decimal hours, and want to convert to a time. Now you
say you have a time, and need the decimal hours. So let's try again:
1. In B1, enter =a1*24
2. Format as a number with two decimal places
2. Copy this formula down to B15
You should now have your results in cells b1:b15. If you don't get the
results you are looking for, it's probably because you have text, rather
than a time. Convert the text to a time (by, for example, using Text To
Columns) in this case.
Regards,
Fred
"Tbazemore" wrote in message
...
Okay... turns out I actually have the hours and minutes in cell A1 thru
a15.
I actually need the hour/hundredth)... Is there a formula? and if so, for
A1
where should I be putting this formula?
Tabatha
"Fred Smith" wrote:
You need to change A1 to whatever cell your hours are in. As you did not
specify any cell addresses, it's impossible for us to know where your
data
is. So we use A1 as a sample.
If you still need help, tell us where your data is (ie E1, A27:A46), and
I need to covert it to hours/hundredths
we'll give you a specific formula.
Regards,
Fred
"Tbazemore" wrote in message
...
Roger,
I have attempted using =A1/24, but its not working.... maybe im putting
it
in the wrong place? is it possible to elaborate a little more on the
"how
to"? I have also been attempting this coversion for my monthly report.
Thanks.
"Roger Govier" wrote:
Hi Ron
Excel stores it's times as fractions of a day (24 hours)
Format the cell as hh:mm
then with 6.15 in cell A1 =A1/24
--
Regards
Roger Govier
"Ron" wrote in message
...
I get an exported excel file that has the time in hours/hundredths
and
I
have
to convert it to hours/minutes - example 6.18 = 6:11, 6.15 = 6:09,
etc.
I'm doing the conversion but it takes me about 4 passes - is there a
simple
way to convert this kind of time. Thank You
__________ Information from ESET Smart Security, version of virus
signature database 4743 (20100104) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus
signature database 4743 (20100104) __________
The message was checked by ESET Smart Security.
http://www.eset.com
.