You really should consider a timestamp or epoch time. I don't know what you mean by "convert the time to decimal", but as others have pointed out, if whatever you're measuring could conceivably cross midnight, your calculations will be wrong.
Please, either tell us :
- that this will never happen, ever.
- that the decimal format you refer to is a timestamp.
| [reply] |