Previous Topic Next Topic

Converting time units to whole no.

Solved/Closed
eyji - Jun 12, 2010 at 06:43 PM
 eyji - Jun 12, 2010 at 11:12 PM
Hello,

Example: start time is 8:00AM and end time is 8:30 AM= total time :30 (cell is formated to time units)...

How do I convert :30 to show only 30? When I try to convert to decimal the number changes to .02083 which is diff. I just want the (:) to remove from the number 30.

thanks for your help

1 reply

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Jun 12, 2010 at 07:01 PM
so what if its 8:00 AM and 9:30 AM?
0
eyji
Jun 12, 2010 at 07:23 PM
I have a conversion table, but i just need to remove the (:) symbol. actually that was my earlier problem too bec the units are not the same anymore when it exceed 59 minutes so I jsut made a conversion table. Can you assist, either way?

I need to convert using 60 minutes as units of measure...That was actually what I was doing orginally...
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Jun 12, 2010 at 07:56 PM
You can format the cell as hhmm or mm
0
eyji
Jun 12, 2010 at 09:02 PM
i did that already, it did not work
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Jun 12, 2010 at 09:18 PM
Are you sure ?
I had 8:00 AM in A1
and 8:30 AM in B1
and in C1=b1-a1 and formatted that to hhmm and i got 0030
0
eyji
Jun 12, 2010 at 11:12 PM
oh you are so right....I tried it again, I overlooked that you removed the (:) symbol in the custom format...thank you so much...you are awesome
0