Ask Your Question

Revision history [back]

Decimal what? minutes? nanoseconds?

Time in LO is actually a fraction of a day that is shown in time format. E.g., 12:00 am is 0.5. You may use something like this: =SECOND(A1)+MINUTE(A1)*60+HOUR(A1)*3600

Decimal what? minutes? nanoseconds?

Time in LO is actually a fraction of a day that is shown in time format. E.g., 12:00 am is 0.5. You may use something like this: =SECOND(A1)+MINUTE(A1)*60+HOUR(A1)*3600=SECOND(A1)/60+MINUTE(A1)+HOUR(A1)*60

Decimal what? minutes? nanoseconds?

Time in LO is actually a fraction of a day that is shown in time format. E.g., 12:00 am pm is 0.5. You may use something like this: =SECOND(A1)/60+MINUTE(A1)+HOUR(A1)*60