I have difficulties with converting from minutes to hours in a cell, ie I would like to enter, for example, 75 minutes in the cell and I would like it to display 1h 15 minutes or 1:15 hours. I can ask someone for help.

And there was nothing about total division and the rest of the division at school? you can, for example, like this: Code: text Expand Select all Copy to clipboard =ZŁĄCZ.TEKSTY(ZAOKR.DO.CAŁK(A7/60);:;MOD(A7;60);h) where cell A7 contains the minutes entered

Link ftp://ftp.helion.pl/online/100e27/100e27-2.pdf

= CONCATENATE (CEILING (A7 / 60); :; IF (MOD (A7,60)

How can it not work? You enter minutes into A7? This is done for the example suggested by will cover . It only changes that it adds 0 minutes before the minutes if there are less than 10. I checked at home and it works without a problem.

Not too much for the display of the result. After entering 65 min, the result is 1: 5h and not 1: 05h.

I understood that it should be displayed like this - 65 min = one hour and 5 minutes, not first five = CONCATENATE (CEILING (A7 / 60), h, MOD (A7,60), min)

This formula doesn't work for me.

Thank you. I hope that this post will never be removed, because I was wondering 2 weeks how to do it myself , I had to modify it a bit and convert it to English but it works. Thank you again

[Solved] EXCEL - Efficient Conversion of Minutes to Hours in Cells: Display Formats 1h 15m or 1:15hrs

tom_asiol 42906 8

Treść została przetłumaczona

Zobacz oryginalną wersję tematu

| New topic

#1 9125055 09 Feb 2011 08:44

tom_asiol tom_asiol

Level 15

» |

Post #1
9125055 09 Feb 2011 08:44

I have difficulties with converting from minutes to hours in a cell, ie I would like to enter, for example, 75 minutes in the cell and I would like it to display 1h 15 minutes or 1:15 hours. I can ask someone for help.
ADVERTISEMENT
Helpful post

#2 9125272 09 Feb 2011 10:06

otapi otapi

Level 25
» | Helpful post? (+3)

Helpful post
Post #2
9125272 09 Feb 2011 10:06

And there was nothing about total division and the rest of the division at school?

you can, for example, like this:

Code: text Expand Select all Copy to clipboard
=ZŁĄCZ.TEKSTY(ZAOKR.DO.CAŁK(A7/60);":";MOD(A7;60);"h")

where cell A7 contains the minutes entered
ADVERTISEMENT
#3 9125813 09 Feb 2011 12:49

tom_asiol tom_asiol

Level 15

» | Topic author Helpful post? (+2)

Post #3
9125813 09 Feb 2011 12:49

Not too much for the display of the result. After entering 65 min, the result is 1: 5h and not 1: 05h.
Helpful post

#4 9125835 09 Feb 2011 12:54

1 PAWEL 1 PAWEL

Level 42

» | Helpful post? (+2)

Helpful post
Post #4
9125835 09 Feb 2011 12:54

Link

http://support.microsoft.com/kb/214094/pl

ftp://ftp.helion.pl/online/100e27/100e27-2.pdf
ADVERTISEMENT
#5 9125839 09 Feb 2011 12:57

otapi otapi

Level 25

» | Helpful post? (+3)

Post #5
9125839 09 Feb 2011 12:57

I understood that it should be displayed like this - 65 min = one hour and 5 minutes, not "first five"

= CONCATENATE (CEILING (A7 / 60), "h", MOD (A7,60), "min")
Helpful post

#6 9125883 09 Feb 2011 13:12

Anonymous Anonymous

Anonymous

» |

Helpful post
Post #6
9125883 09 Feb 2011 13:12

tom_asiol wrote:
Not too much for the display of the result. After entering 65 min, the result is 1: 5h and not 1: 05h.

= CONCATENATE (CEILING (A7 / 60); ":"; IF (MOD (A7,60)
ADVERTISEMENT
#7 9125887 09 Feb 2011 13:13

tom_asiol tom_asiol

Level 15

» | Topic author Positive voted Helpful post? (+6)

Post #7
9125887 09 Feb 2011 13:13

This formula doesn't work for me.
Helpful post

#8 9125899 09 Feb 2011 13:16

Anonymous Anonymous

Anonymous

» |

Helpful post
Post #8
9125899 09 Feb 2011 13:16

How can it not work? You enter minutes into A7?
This is done for the example suggested by will cover .
It only changes that it adds 0 minutes before the minutes if there are less than 10.

I checked at home and it works without a problem.
#9 17179781 21 Apr 2018 09:59

Malim Malim

Level 2

» | Helpful post? (0)

Post #9
17179781 21 Apr 2018 09:59

Thank you. I hope that this post will never be removed, because I was wondering 2 weeks how to do it myself , I had to modify it a bit and convert it to English but it works. Thank you again
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

| New topic

Report a violation of the law

Topic summary

The discussion revolves around converting minutes to hours in Excel cells, specifically aiming for formats like "1h 15m" or "1:15 hours." Users share various formulas to achieve this, such as using CONCATENATE and CEILING functions. One suggested formula is =CONCATENATE(CEILING(A7/60), "h", MOD(A7,60), "min"), which formats the output correctly. However, some users encounter issues with leading zeros in the hour display. Additional resources, including links to Microsoft support, are provided for further assistance.
Summary generated by the language model.

[Solved] EXCEL - Efficient Conversion of Minutes to Hours in Cells: Display Formats 1h 15m or 1:15hrs

Didn't find an answer? Ask Artificial Intelligence

Topic summary