Hi Hui,
Thanks for replying & welcoming me to the Forum.
When I tried using the formula you have suggested, the following happens:
A1 = 34:02:04 (The formula bar shows: 1/1/1900 10:02:04 AM) - got from data dump
B1 = INT(A1*24)/24 gives me 10:00:00
But, I want the B1 value to be...
Hi,
I have a column named "Elapsed Open Time' and the data is in the format HH:MM:SS.
The HH is not restricted to max limit of 24. So, a sample data is "34:20:12" meaning the particular record is 34 hours 20 min and 12 seconds old.
I need to extract the HH value alone(in this case, only...