Help

**boyd** · 02-08-2005, 04:40 PM

Please help how do i get a time from a decimal ie: 1.5 to equate to timings ie: 1hr 30 mins. sorry if its a bit basic but i'm really struggling have spent all day trying to sort this one and everyone is stumped

**BenjieLop** · 02-08-2005, 05:48 PM

Originally Posted by boyd

Please help how do i get a time from a decimal ie: 1.5 to equate to timings ie: 1hr 30 mins. sorry if its a bit basic but i'm really struggling have spent all day trying to sort this one and everyone is stumped

This is your formula ...

=int(A1)&" hr "&mod(A1,1)*60&" min"

where A1 contains the number that you want to convert.