Previous Topic Next Topic

Time conversion

Closed
eyji - Jun 16, 2010 at 10:23 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 17, 2010 at 05:53 AM
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

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 16, 2010 at 10:26 PM
What do you mean by "30/60 minutes. WHen I do this it is converting 30 into another units."
0
eyji
Jun 16, 2010 at 10:49 PM
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
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 17, 2010 at 05:53 AM
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 ?
0

Similar discussions

The system time is invalid
LeonardPromise -
Anonymous User -

5 responses