In the attached file I have time as h:m:s. I need to separate this data to three columns of Hours, Minutes and Seconds. I have put formulas in cells B-D and they work for the last two. The Hours column works until it is over 24, then I do not understand the number returned.
Thanks in advance.
Bookmarks