T
Thurlow
Having trouble converting decimal days to days, hours, minutes, & seconds.
For example, I would like to see:
16.4543 Days
become
16 Days
10 hours
54 minutes
12 seconds
Have tried using the RIGHT and CONVERT functions, but the RIGHT logic fails
if I have a whole number for days to start with (no places right of the
decimal).
Any thoughts?
For example, I would like to see:
16.4543 Days
become
16 Days
10 hours
54 minutes
12 seconds
Have tried using the RIGHT and CONVERT functions, but the RIGHT logic fails
if I have a whole number for days to start with (no places right of the
decimal).
Any thoughts?