Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default tracking time

greetings all,
I have a file where i am tracking time. periodically a new line is added
with the new time. for reason difficult to explain, periodically, the time
gets reset to zero i.e. starts over. currently i am using format dd:hh:mm:ss
this works well but occasionally the time runs beyond 30 days(1 month) and
the above format resets to day 1 when it goes beyond 30 day(1 month?). i have
tried dilffernts format to try and make the days roll over ie 35:00:00:00 but
to no avail.
[dd]:hh:mm:ss doesn't work.
can someone give me some pointers/tips/directions on my dilima.

help would be most appreciated.
regards
FSt1

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Tracking Help Sri Excel Discussion (Misc queries) 0 April 1st 08 01:38 PM
Help with time (shift) tracking Makenzi Excel Discussion (Misc queries) 0 April 11th 07 08:30 PM
Tracking Time CCS Excel Worksheet Functions 1 July 12th 06 12:27 AM
Tracking Time brucek Excel Discussion (Misc queries) 1 March 22nd 06 09:16 PM
Tracking time Hans Peter Excel Worksheet Functions 1 March 18th 06 08:07 PM


All times are GMT +1. The time now is 11:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"