"SteveG" wrote in
message ...

Assuming your value is in A1

=CONVERT(A1,"day","hr")

But remember that the CONVERT function is only available if the Analysis
ToolPak add-in is installed.
--
David Biddulph