Hello,
I am having problems converting hours, minutes, and seconds to decimal time.
Example:
I have 08:32:24 in cell A1.
I use this formula in B1: =(A1-INT(A1))*24
But I get the #VALUE! error. I tried chaning the format of the cell, but that didnt work.
I know there is a way to manually calculate out the minutes and seconds, but I need to do this for many differnet fields with different values, so I am looking for a quick formuala.
Any help would be appreciated. Thank you.
I am having problems converting hours, minutes, and seconds to decimal time.
Example:
I have 08:32:24 in cell A1.
I use this formula in B1: =(A1-INT(A1))*24
But I get the #VALUE! error. I tried chaning the format of the cell, but that didnt work.
I know there is a way to manually calculate out the minutes and seconds, but I need to do this for many differnet fields with different values, so I am looking for a quick formuala.
Any help would be appreciated. Thank you.