what i know as Time Lapse

[johnneyred]

i wish to set up an exel doc to keep track of time

Senario; i install hard drives into DVR units and need to be replaced every 20,000 hrs

also need to know how many hrs hdd have been installed and running for @ any given time


Question how do i set up an exel doc so i can enter ie todays date and time along with other client details and say press go

in another cell time starts and keeps running

so at any other given time i can open this doc and see how long the timer has been running

would also like to incorperate a flag when time gets to 19,500 hrs cell turns red

i feel this may be relitivly complicated and i have very little experience with excel

as much detail as psible pls

thank you

 

[Hui]

Johnneyred


I wouldn't worry to much about the exact time in Hrs as 24 hrs in 20,000 is a very low %, Just concentrate on the days

I would setup the following columns

Column A - Hard Disk ID

Column B - Date Installed

Column C - Today date

Column B & C both have Date format to suit yourself

Column D - Operating Hrs

Column E - 19500 Warning

In Operating Hrs D2 I would have =+(C2-B2)*24 and format that as a Number

In Column E2 I would have =+IF(D2>19500, "Warning","Ok")

and then set Conditional formatting to show when Warning in Bold Red when it is "Warning"


Have a look at

http://rapidshare.com/files/347079858/HD_Warning.xls

 

[johnneyred]

thanks HUI

works a treat

is it posible to have todays date colmn auto update when i open exel doc

if u can imagine i have over 50 clients with more than 20 dvr's each

that is alot of data entry every time i wish to update my doc

any suggestions

thanks again

 

[Hui]

Press F9 that will update it