Hello

i have this bit of code that i would like it to format as time when
the value is added to the cell

ActiveCell.Offset(0, 7).Value = Round(CallmediaAveHandlingHours /
NumberofWeekstoSummary, 2)

The CallmediaAveHandlingHours value is a total time taken from several
different worksheets.

Many Thanks

Stuart