Is there a simple way to convert a number representing minutes into hours and minutes?
EX:
A l B l C
TOTAL MIN l Hours l Min
135.37 l 2 l 15.6
OR
A l B
TOTAL MIN l CONV
135.37 l 2:15:36
Is there a simple way to convert a number representing minutes into hours and minutes?
EX:
A l B l C
TOTAL MIN l Hours l Min
135.37 l 2 l 15.6
OR
A l B
TOTAL MIN l CONV
135.37 l 2:15:36
Try
=A1/(24*60)
Format as Custom
[h]:mm
Try in B1: =ROUND(A1/60,0) and in C1: =ROUND(A1-60*B1,0) That gives you hours then minutes and then if you wanted in D1 put =ROUND(60/(((A1)-(B1*60)-C1)*10),0) which gives you seconds
Thanks guys. This gives me a few ways to format!
@Thalassa & @amotto11
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks