Time conversion

Closed
eyji - Jun 16, 2010 at 10:23 PM
rizvisa1
Posts
4479
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?

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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