Thread: convert a number of seconds to HH:MM:SS?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steff_DK[_21_] Steff_DK[_21_] is offline
external usenet poster
  
Posts: 1
Default convert a number of seconds to HH:MM:SS?
I use timer in my code.
It calculates the time elapsed by subtracting a number of seconds fro
another number of seconds e.g. 50256.3470 - 40155.1

The value returned, should be in the format HH:MM:SS.

How is this done in code?

I dont want to write any functions into ranges on the sheet or forma
any cells...

Thanks!!

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote