0
I want to have a string value prepended to a XL-style formating in a spreadsheet program (gnumeric). The current formatting is [$-f4f2]hh:mm
which should take 1:00 PM
as input and convert/display it as 13:00
. Additionally I would like to have it prepend the character @
, such that with input 5:55pm
the cell converts it to @17:55
.
I am asking on Super User since it was suggested as a good site for Excel-type questions in another user's Q/A on meta 1,2.
I've already tried stuff such as CONCATENATE("("a") ", [$-f4f2]hh:mm)
and [$-f4f2]hh:mm & "@"
based on this post.
How does the formula that converts 12 hour time to 24 hour time work? – Raystafarian – 2014-10-23T16:15:19.363
@Raystafarian I'm not actually sure, it is included as a custom format example in gnumeric. It does work though. – ConfusedStack – 2014-10-23T16:21:59.297
In Excel I'd use
TEXT()
for the reformatting of the time. I'm not acquainted with gnumeric. – Hannu – 2014-10-23T20:25:24.980