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]
