×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Microsoft: Office FAQ

## Date/Time Functions

 How to convert hours/mins/seconds greater than one day to seconds by Mikeauz faq68-5445 Posted: 27 Sep 04 Hi,In converting Hours:Mins:seconds to seconds I was always a beleiver of using =(HOUR($A1)*3600)+(MINUTE($A1)*60)+(SECOND(\$A1)) but recently discovered that Excel stores times greater than 24 hours as days/months/years/hours/minutes/secondsTo get around this problem paste the following into a module:Public Function TSITSeconds(CellName) As StringDim Result, TotResult As StringDim newname As IntegerTotResult = 0newname = Int(CellName)TotResult = (newname * 86400)TotResult = TotResult + (Hour(CellName) * 3600)TotResult = TotResult + (Minute(CellName) * 60)TotResult = TotResult + (Second(CellName))TSITSeconds = TotResultEnd Functionand to use it type this in your excel sheet:=TSITSeconds(YourCellAddress)This will give you youre answer in secondsHope it HelpsMike Back to Microsoft: Office FAQ Index Back to Microsoft: Office Forum

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!