View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default how to turn decimal hours into hours and minutes?

Hi Josh,

Divide the number 237.83 by 24 and use number format-custom and set the
format to [h]:mm
--
Regards,

OssieMac


"Josh" wrote:

i want to display my vacation hours as as hours and minutes. right now lets
say i have 237.83 displayed. i would like to find a way to display this as
"237 hours 50 minutes". if i can get with text, that would be great. if not,
i can work with that as well.