Real Big Time

This allows really large time values like when adding work hrs or AHT etc. Its for use when excel starts reporting over 24hrs as a day e.g. 42hrs would report as 1day 22 hrs.

Public Function RealBigTime(hr As Double, _  min As Double, sec As Double) As Double Dim hr1 As Double Dim min1 As Double Dim sec1 As Double Application.Volatile hr1 = hr / 24 min1 = min / 24 / 60 sec1 = sec / 24 / 60 / 60 RealBigTime = hr1 + min1 + sec1 End Function

Code Snippits