PDA

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