VB and VBA Users Source Code: Re: Excel VBA: Simple Formula to convert a times into total hours, minutes or seconds
[
Home
|
Contents
|
Search
|
Reply
|
Previous
|
Next
]
VB/VBA Source Code
Re: Excel VBA: Simple Formula to convert a times into total hours, minutes or seconds
By:
Le Van Duyet
Email (spam proof):
Email the originator of this post
Date:
Monday, December 24, 2007
Hits:
4646
Category:
VBA (Visual Basic for Applications)
Article:
Function NumSecs(timeSpan As Variant) As Variant Dim res As Double Application.Volatile True res = CDbl(timeSpan) * 24 * 60 * 60 NumMins = res 'Please adjust this section End Function
Terms and Conditions
Support this site
Download a trial version of the Excel Workbook Rebuilder
