Converting number into hours and minutes

[nishanthi_8]

Hi,

I have  20.66 in number format i want to convert it into hours and minutes i .e is 21:6 .any solution for this .

[Gysbert_Wassenaar · Accepted solution]

Interval( MyNumber / 24 , 'hh:mm')

[Anonymous]

Time(  COMP_DAILY_ID,'HH:MM')

[stigchel]

Something like this

Time((Left(20.66,2)*60+right(20.66,2))

/(24*60)

,'hh:mm')

[stigchel]

I should add that it might very well be that Gysbert's solution is correct and that your assumption the outcome should be 21:06 is wrong. My suggestion results in your stated expected outcome, but 20.66 as a number would be a weird notation for that. Where did it come from?

[nishanthi_8]

the number should be converted is what i mean

[Digvijay_Singh]

=text(subfield('20.66','.',1)+ div(SubField('20.66','.',2),60)) & ':' & mod(SubField('20.66','.',2),60)