CODEWITHSUNDEEP
excelexcel-formula
Qi Xuan
Qi Xuan

Reputation: 43

Excel formula minutes to hours in text format

I want to convert minutes to hours in text format

text minutes = 291

How to convert it to 4.51 (means 4hrs 51min)

I don't use time format or ":" because have a lot data to key in, number pad is good for key in much data.

Thanks help!

Upvotes: 0

Views: 256

Answers (2)

pykam
pykam

Reputation: 1481

You can do use the CONCAT and MOD function and do something like the example below.

I'm giving pseudo-code as you haven't specified any cell ranges.

= CONCAT(INT((text minutes)/60), '.',MOD((text minutes),60)

Remember that the CONCAT method returns a string and not an integer.

Upvotes: 1

JvdV
JvdV

Reputation: 75840

You could use:

=TEXT(291/1440,"[h].mm")

Not sure what you meant with "I don't use time format or ":" because have a lot data to key in, number pad is good for key in much data.". But the above returns a text-string of 4.51.

The [h] is meant to count beyond 24 hours if 291 could exceed 1440.

Upvotes: 1

Related Questions