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.
ConfusedStack
Posted 2014-10-23T15:50:07.757
Reputation: 131
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