Cell format: date/time with time in bold?

Discuss the spreadsheet application

Cell format: date/time with time in bold?

Postby stormrider10001 » Fri Jan 25, 2008 6:33 pm

By the following Datecode, I want to have the time in bold and the date normal:

TT.MM.JJJJ HH:MM:SS

I thought and tried to do it like red-shown numbers less than zero (#.##0,00" €";[ROT]-#.##0,00" €)
and typed TT.MM.JJJJ [bold]HH:MM:SS
But it doesn't work.

I would be very grateful, if someone can tell me how to do that or if there's a possibility to fix this
stormrider10001
 
Posts: 7
Joined: Fri Jan 25, 2008 6:21 pm

Re: Cell format: date/time with time in bold?

Postby acknak » Fri Jan 25, 2008 6:46 pm

[Split to new topic] Don't be shy to start a new topic, even if it is similar to an existing one. It get's very confusing to have two separate discussions in one thread.

I don't think this is possible using only a cell format. The only attribute that is available is the color, and that is very limited.

Can you display the time in a separate column?
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Cell format: date/time with time in bold?

Postby stormrider10001 » Fri Jan 25, 2008 6:58 pm

I can't use another cell, because it's a result of a function.

For example

known times:

start-time 25.01.2008 16:00:00
duration: 04:00:00

the result is (by using f.ex. C4-B4): 25.01.2008 20:00:00

The time is more important than the date, so I would like it shown in bold
stormrider10001
 
Posts: 7
Joined: Fri Jan 25, 2008 6:21 pm

Re: Cell format: date/time with time in bold?

Postby acknak » Fri Jan 25, 2008 7:38 pm

So in one cell, say D4, you write your function: =C4+B4 and format that to show only the date. In another cell, say E4, you write =D4 and you format that cell to show only the time, in bold.
time_bold.png
time_bold.png (4.24 KiB) Viewed 1829 times
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: No registered users and 32 guests