Convert hours to days-hours
Hi,
Can anyone help me with a VBA UDF to convert Hours to Days-Hours
format.
I have a UDF function which returns value in Hours e.g. 25 formatted
as [hh] & i want to change it, or supply that return value to another
UDF function that will return a value in Days-Hours format e.g. "3
Days-4 Hours".
The Days should be calculated as 9 Hours=1 Days.
If anyone good in VBA has understood what i am trying to do, i would
appreciate their help!
Cheers!
|