How to Convert Seconds from sum of Hour.
hi
fine here.
How it possible ? hour convert into seconds.
total sum of hour :- 250:35 (HH:MM)
returns :
( calculate total Second )
thanks friends.
GoodBye.
[203 byte] By [
LiveSys] at [2007-11-11 10:25:08]

# 1 Re: How to Convert Seconds from sum of Hour.
Dim TotalTime As String
Dim TimeParts() As String
Dim Hours As Long
Dim Minutes As Long
Dim Seconds As Long
TotalTime = "250:35"
TimeParts = Split(TotalTime, ":")
Hours = CInt(TimeParts(0))
Minutes = CInt(TimeParts(1))
Seconds = (Hours * 3600) + (Minutes * 60)