I have a python script that collects a bunch of data. At the end, it prints the collected data to an Excel spreadsheet. One of my columns is displaying the "Time Elapsed" in a form of minutes:seconds. My python script has already given the entire column a "Custom" number format of
mm:ss, and provides all the data in such form.
For some reason though, I can't seem to get any functions to work with this data, unless I go into the cell and press Enter. Now, turning on "Show Formulas". I see that the cell is not a time at all to Excel, but instead a decimal number, and I can't figure where it gets it from. After pressing enter and getting the decimal, functions work with the data.
I'm probably being dumb here.. but can someone tell me how Excel converts
1:49 (1 minute:49 seconds) to
0.075694444444? I also see that after pressing Enter in the cell, it converts
1:49:00 AM, which is not applicable to my situation.
I'm really sorry if I worded this poorly. Any thoughts / ideas are welcome.