Previous Topic Next Topic

Time conversion

Closed
eyji - 16 Jun 2010 à 22:23
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Jun 2010 à 05:53
Hello,
I have asked this earlier last week and got the answer however I think I asked a wrong question for what I really needed. I just asked how to format the answer into hhmm.

What I need actually is how to make excel compute result(in hr format) /60 minutes, eaxmple below:


ex: start time 8:00AM
end time 8:30 AM
total time :30
I need to have excel ----30/60 minutes. WHen I do this it is converting 30 into another units. Can you help me please?
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
16 Jun 2010 à 22:26
What do you mean by "30/60 minutes. WHen I do this it is converting 30 into another units."
eyji
16 Jun 2010 à 22:49
the result of 30 minutes is in hr format, i need to get the no. 30 (as 30 only not in hr unit) and divide by 60 to convert into minutes. But is is giving me anotehr answer that is not correct. can you try it and see
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
17 Jun 2010 à 05:53
I am sorry but I am not getting you. When I subtract the two time, it is 30 minutes. And thats what it is showing. If the difference was 1 hour and 30 minutes, it would have shown 0130. So what exactly are you asking. Are you saying that you would rather have 90 minutes instead of 1:30 ?

Similar discussions

The system time is invalid
LeonardPromise -
Anonymous User -

5 responses
how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response