Does anyone know of a way to do this so i can just enter 4.11? Thanks :
S smith.james0 Nov 12, 2004 #1 Does anyone know of a way to do this so i can just enter 4.11? Thanks :
A Aladin Akyurek Nov 12, 2004 #3 =("0:"&SUBSTITUTE(A1,".",":"))*86400 smith.james0 said: Does anyone know of a way to do this so i can just enter 4.11? Thanks : Click to expand...
=("0:"&SUBSTITUTE(A1,".",":"))*86400 smith.james0 said: Does anyone know of a way to do this so i can just enter 4.11? Thanks : Click to expand...
