First time here? Check out the FAQ!

1 | initial version |

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`

2 | No.2 Revision |

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

3 | No.3 Revision |

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`

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.