View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Yvonne,

Just add them, and format the result cell as time. Time is just a fractional
number in Excel, and it is the display for mat that makes it look like time.

--
HTH

Bob Phillips

"
osoft.com wrote in
message ...
Hi

I need to add times together, i.e. 6:30, 5:30, 5:00 etc to get and answer

of
17 hours

Can someone help me with the formula please.

Thanks
Yvonne