Time Calculations that roll past 24 Hrs

R

rocketslinger

How do I prorammatically enumerate time past 24 Hrs and accuratel
format the result for display in a userform (ex. 100:30 hrs)
Suggestions greatly appreciated
 
R

Rob van Gelder

Work with dblHours
Int(dblHours) & ":" & Format(Int((dblHours - Int(dblHours)) * 60), "00")
 
J

J.E. McGimpsey

One way:

Textbox1.Text = Application.Text(myTime, "[hh]:mm:ss")

where myTime is your time value.
 
R

rocketslinger

Thanks guys for the assistance. Your suggestions helped me reach my end
result.
 
Top