Time question

[gruney]

Is there any way to show time in a cell but only have it change when 5 minutes elapses. So for example, i have the time 12:00 in a cell, I would not want this time to change until the time is 12:05. I would prefer to do this without using vba if possible.

thanks all

 

[c_m_s_jr]

You need to use VBA to get that to work.

Otherwise you could use the NOW() function and format to to just show the TIME and it would update everytime someone hits enter, or the sheet recalcs, or when the sheet opens, but doubtful that is what you really want so your left with VBA.

 

[gruney]

if vba is all i can use then ill guess ill have to, i am just not very good with it...anyone point me in the right direction?

 

[c_m_s_jr]

There should be some good examples on the board. Try searching for TIMESTAMP macro or TIMESTAMP and VBA. Maybe narrow it down by searchign for user VoG. I know he has posted stuff similar to your request.

 

[daffy]

http://www.cpearson.com/Excel/OnTime.aspx

You may need to use an on time event, see the link above


don