UDF for converting seconds

[wayneg]

hi all,

I wrote this function to convert cells containing Hrs, Minutes and second into just seconds

Please Login or Register  to view this content.

but i also need one to do the opposite,

i started with

Please Login or Register  to view this content.

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"

any help please

thanks, wayne

[nathansav]

Hours

=INT(F4/3600)

Minutes

INT((F4-(INT(F4/3600)*3600))/60)

Seconds

(F4-(INT(F4/3600)*3600))-(INT((F4-(INT(F4/3600)*3600))/60)

Where f4 is your value, i did it in the worksheet for speed.

[sweep]

Please Login or Register  to view this content.

[Jakobshavn]

Very easy:

Please Login or Register  to view this content.

[nathansav]

Nice idea Jako, i thought that would have errored when over 60, nice touch, i'll use that :o)

[wayneg]

ty Jakobshavn , that was exactly what i needed. i assume my approach on calculating things was wrong. i just need to find out now how to save this function so its applicable every time i open excel irrespective what file it is.