View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SmilingPolitely SmilingPolitely is offline
external usenet poster
 
Posts: 18
Default Formatting times

I am trying to write a function to display the time elapsed since
StartTime and Now() and have it formatted as H:mm:ss

I tried this code:

Format(DateDiff("s", StartTime, Now()), "H:mm:ss")

but without result.

Can someone please help?