ExcelBanter - Time Calculations that roll past 24 Hrs

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Time Calculations that roll past 24 Hrs (https://www.excelbanter.com/excel-programming/285908-re-time-calculations-roll-past-24-hrs.html)

Rob van Gelder[_2_]

Time Calculations that roll past 24 Hrs

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

"rocketslinger" wrote in message
...
How do I prorammatically enumerate time past 24 Hrs and accurately
format the result for display in a userform (ex. 100:30 hrs)?
Suggestions greatly appreciated.

---
Message posted from http://www.ExcelForum.com/

rocketslinger

Time Calculations that roll past 24 Hrs

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

---
Message posted from http://www.ExcelForum.com/

All times are GMT +1. The time now is 05:06 PM.