Time Calculations that roll past 24 Hrs

  • Thread starter Thread starter rocketslinger
  • Start date Start date
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
 
Work with dblHours
Int(dblHours) & ":" & Format(Int((dblHours - Int(dblHours)) * 60), "00")
 
One way:

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

where myTime is your time value.
 
Back
Top