Hi Michael

the first part is using the format claus for cells, columns or raws.
the second part is using formulas like hour, minute,second (maybe the fault term, I've only the German version of OOO installed)
for all it is necessary that the format for the target cells is HH:MM:SS

Franz

John Meyer schrieb:
Michael Adams wrote:
In "Format - Cell" you can modify how this data looks using the format
code. Your second cell only needs "=x1" (or the address of the first
cell) as it's formula.



That's a start, and I should have added that I want it to be expressed as ##:00. In other words, truncate the hour. When I try to do that by just putting HH:00 I don't get the proper formatting.


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]





---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to