Thread: Time Calculations that roll past 24 Hrs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_2_] Rob van Gelder[_2_] is offline
external usenet poster
  
Posts: 11
Default 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/



Reply With QuoteReply With Quote