Make decimal number into time

[mguidry5]

Howdy,

How can I make this number (2.97, which represents just under 3 days) into a time value in the format of h:nn:ss?

TIA

MJG

 

[67peshawar294]

multiply the first digit(s) by 24.
2 * 24 = 48
Multiply the decimal by 60.
.97 * 60 = 58.2
Multiply the result decimal by 60
.2*60=12
concantate...48 hrs 58 min 12 sec
jim

 

[mguidry5]

Thanks, xaf294. I figured it out after a little more looking and scavenging on the web. I'm a little s l o w when it comes to vba.

Thanks again for the response,

MJG