guamlenahans
Board Regular
- Joined
- Oct 25, 2006
- Messages
- 113
I am using a sheet that calculates scores based on time. The sheet requires the time to be in a decimal format, i.e 13.51
However, the database I pull the info from uses this format: 13:51
Is there a quick way I can convert the numbers? I have tried to relace the : with a . but it changes the cell formatting.
Thanks in Advance
Rob
However, the database I pull the info from uses this format: 13:51
Is there a quick way I can convert the numbers? I have tried to relace the : with a . but it changes the cell formatting.
Thanks in Advance
Rob