Ask Your Question

Unable to do conditional formatting on columns containing time values [closed]

asked 2012-05-05 08:53:57 +0200

saji89 gravatar image

updated 2012-05-05 09:04:20 +0200

Hi, I'm trying to give conditional formatting to a column in LibreOffice Calc containing time values. I have selected the column format as Time format(HH:MM:SS) Now when I try conditional formatting on this column, for e.g, to highlight all fields with time greater than 09:30, all the fields get highlighted, except the blank cells in between.

Related image: I was unable to upload a picture here, so I have uploaded at The url is:

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 00:33:02.476918

1 Answer

Sort by » oldest newest most voted

answered 2012-05-05 11:03:00 +0200

Pedro gravatar image

You probably typed 9:30 in the condition field. While Excel is clever enough to accept 9:30 (and then converts it to number in the background), Calc doesn't.

(You can check in Excel that if you return to the Conditional Formatting dialog instead of 9:30 there is 0.395833333333333)

You have two options: type the actual value (in this case 0.395833333333333) or point to a cell which contains your condition in time format i.e. just have a cell somewhere in the spreadsheet or on another sheet with 9:30

In addition you can add this as a request for an enhancement in

edit flag offensive delete link more

Question Tools


Asked: 2012-05-05 08:53:57 +0200

Seen: 2,365 times

Last updated: May 05 '12