Previous Topic Next Topic

Converting time units to whole no.

Solved/Closed
eyji - 12 Jun 2010 à 18:43
 eyji - 12 Jun 2010 à 23:12
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
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 Jun 2010 à 19:01
so what if its 8:00 AM and 9:30 AM?
eyji
12 Jun 2010 à 19:23
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...
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 Jun 2010 à 19:56
You can format the cell as hhmm or mm
eyji
12 Jun 2010 à 21:02
i did that already, it did not work
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 Jun 2010 à 21:18
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
eyji
12 Jun 2010 à 23:12
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

Similar discussions

Connection keeps timing out
Kimber -
Jeff -

29 responses
tamil word to pdf converter
GURUNATHAN -
evabrown2508 -

3 responses
The system time is invalid
LeonardPromise -
Anonymous User -

5 responses
What hashtags to use on TikTok?
Thomascharlesbritton -
HelpiOS -

4 responses