Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Convert a time to the decimal equivalent
- Thread starter okuser
- Start date
synapsevampire
Programmer
Is this an actual time data type, or a string containing the time?
I'll assume the latter as most databases don't store a TIME type:
If val(mid({table.field},instr({table.time},":"
+1) > 0 then
val(left({table.field},instr({table.time},":"-1)+
60/val(mid({table.field},instr({table.time},":"+1)
else
val(left({table.field},instr({table.time},":"-1)
Couldn't test right now, but that looks right.
-k
I'll assume the latter as most databases don't store a TIME type:
If val(mid({table.field},instr({table.time},":"
+1) > 0 thenval(left({table.field},instr({table.time},":"
-1)+60/val(mid({table.field},instr({table.time},":"
+1)else
val(left({table.field},instr({table.time},":"
-1)Couldn't test right now, but that looks right.
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question