View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Time / Each Second Bewtween 9:30 AM and 4:15 PM

I a trying to generate a column that will list each second from 9:30Am until
4:15 PM.

My time format needs to look like this:

Time

93000

93001

93002

etc

93059

93100

93102

etc

95959

100000

100001

100002

etc

161500

Where the last entry 161500 is 4:15 PM.

Is there a good way to do this ?

Thank you in advance.