hi all,
I wrote this function to convert cells containing Hrs, Minutes and second into just seconds
but i also need one to do the opposite,Function TotalSeconds(Hours, Minutes, Seconds) TotalSeconds = (Hours * 60 * 60) + (Minutes * 60) + Seconds End Function
i started with
but want i need is for the output to say (as an example) 4002 seconds as "1 hr(s) 6 minutes(s) and 42 seconds"Function Clock(Seconds) Clock = (Seconds / 60 / 60) End Function
any help please
thanks, wayne
Bookmarks