Thread: Format Cell as Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] stuarttottle@hotmail.com is offline
external usenet poster
  
Posts: 2
Default Format Cell as Time
easier then i thought

ActiveCell.Offset(0, 7).Value =
Format(Round(CallmediaAveHandlingHours / NumberofWeekstoSummary, 2),
"Long Time")

Thanks

Reply With QuoteReply With Quote