Time question

gruney

New Member
Joined
Sep 15, 2009
Messages
5
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
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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.
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top