Hi,
I have a column of numbers in excel that represent the time and are in the following format say 1.30.What I would like to do is change this to a different format to read 1:30.Does anyone know a formula I could use to solve this problem?
Thanks
Hi,
I have a column of numbers in excel that represent the time and are in the following format say 1.30.What I would like to do is change this to a different format to read 1:30.Does anyone know a formula I could use to solve this problem?
Thanks
=time(int(a1),(a1-int(a1))*100,0)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
is 1.3 one hour 30 mins or one hour 18 mimutes?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Its one hour 30 mins thanks
Thanks for your help,it works but inserts am beside the number.Is there any way of deleting this?
Reformatting the cell as one of the options under Time should resolve this (I think)
That worked,thank you so much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks