V vinayadas New Member May 18, 2016 #1 Please guide me to change the value of a cell in "hours" and "minutes" using custom formatting. e.g. 1.25 as "1 hr 30 min" Vinayadas P V
Please guide me to change the value of a cell in "hours" and "minutes" using custom formatting. e.g. 1.25 as "1 hr 30 min" Vinayadas P V
Luke M Excel Ninja Staff member May 18, 2016 #2 Hi vinayadas, and welcome to the forum! How does 1.25 correlate to 1 hour 30 minutes? I can see possibly 1.5 = 1:30, but 1.25?
Hi vinayadas, and welcome to the forum! How does 1.25 correlate to 1 hour 30 minutes? I can see possibly 1.5 = 1:30, but 1.25?
Chihiro Excel Ninja May 18, 2016 #4 Either case, I believe you need 2 steps. Assuming that the number is in A1. In B1: =A1/24 Custom format for B1: h" hr" m "min"
Either case, I believe you need 2 steps. Assuming that the number is in A1. In B1: =A1/24 Custom format for B1: h" hr" m "min"
V vinayadas New Member May 18, 2016 #5 Thank you all for your valuable replies. Actually i meant to format 1.25 as "1 hr 15 mins" Sorry for the confusion. Chihiro, i tried your codeand its working fine. Can we do the same in a single cell? Means without taking into an another cell to devide it by 24?
Thank you all for your valuable replies. Actually i meant to format 1.25 as "1 hr 15 mins" Sorry for the confusion. Chihiro, i tried your codeand its working fine. Can we do the same in a single cell? Means without taking into an another cell to devide it by 24?
Chihiro Excel Ninja May 18, 2016 #6 I don't think so. At least not without overwriting what's in the cell.
