Ask Your Question

Calculating elapsed time problems

asked 2016-08-01 03:47:29 +0200

swest gravatar image

I am new to LibreOffice. The formula to calculate the elapsed time works in Excel but it's not working in LibreOffice. I found this to try - and it worked when I inputted it on my windows PC Excel spreadsheet. So I used it on LO and the time difference I get from 10am to 6pm is .333. What am I doing wrong?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-08-01 11:00:36 +0200

karolus gravatar image


There is nothing wrong - Calc stores Timedurations internally in units of Days→ so 8h resolves to 0.333…(days)

Format the Formulacell into some Time-Format - for Example Number-Formatcode [hh]:mm should be good…

→Rightclick→→Format Cell→Number→Numberformatcode…[hh]:mm

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-08-01 03:47:29 +0200

Seen: 327 times

Last updated: Aug 01 '16