View Full Version : Solved: Find and Replace for Time
r_know
07-24-2012, 08:25 AM
Dear All,
I want Find and Replace function for "Time".
00:00 to 24:00
Pls advise...
Regards,
RL
Kenneth Hobs
07-24-2012, 08:45 AM
The shown value is the same but the actual value is number of days. So 00:00 is shown for no days or the start of any day. If you enter 24:00, the value is 1 but shown as 00:00. 48:00 is shown as 00:00 but a value of 2 days, and so on. If you need something else, try a helper column.
r_know
07-24-2012, 08:52 AM
ohh
Now I will by hard learn, that just need ,
CTRL+F
Replace
0 value for 00:00
1 value for 00:00 hrs but which actually 24:00
thanks
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.