How to convert field with decimal time e.g 11.5 to 11h:30m in Access

[Course]

How do I convert a number field which stores time as decimals(e.g 11.5 means 11hrs 30mins) to a date/time field so that it appears like this 11h:30m.

Thank you

 

[shg]

Row\Col	A​	B​	C​
1​	11.5​	11h:30m​	B1: =A1/24
2​			Format of B1: h\h:mm\m

 

[Course]

Thanks shg, I forgot to mention I also need to convert negative decimal time e.g -2.5 to -2h:30m.

the reason is Im logging UTC timezones and some of them have UTC -2.5 like St Johns in Canada.

Thanks for getting back to me

 

[shg]

Doh -- Joe4 just pointed out that this is an Access forum, of which I know nothing -- sorry.

 

[Course]

I used a calculated field to do what you advised e.g [UTC]/24 which worked the same way. UTC is the field that contains the decimal times.

the problem is it displays the negative times as positive.