Cell format: date/time with time in bold?

[stormrider10001]

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

[acknak]

[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?

[stormrider10001]

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

[acknak]

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 (4.24 KiB) Viewed 2504 times