View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WxmanPrice WxmanPrice is offline
external usenet poster
 
Posts: 1
Default Converting work hours to day/hours/minutes

I am trying to display various work hours/shifts as days:hours:minutes.

For example 457.50 hours or 457:30 would be displayed as 61:00:00 or just 61
days (doesn't matter which is displayed whatever is easier) based on a 7.5
hour work day.

I'd also like to have 2 additional columns. The next would be the above
based on a 9.0 hour work day and the other based on a 9.5 hour work day. The
9.5 work day would be displayed as either 48:01:30 (all I can get it to show
is 48:09).

Any thoughts?