YOu can add the values if the cells contain the time values 12:30:00 and
1:45:45, but not if they contain the exact text (with hr, min, and sec
embedded) that you show in your message.
On Mon, 19 Sep 2005 11:21:05 -0700, "Neville"
wrote:
How can I add two or more sets of hours:minutes:seconds? For example, if I
add 12hr30min00sec to 1hr45min45sec I should get 14hr15min45sec.
|