View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bikierguy bikierguy is offline
external usenet poster
 
Posts: 3
Default adding up total time

I would like to know how to format simple hours to add up in hours vs. 24
hour clock time. Here is an example of what I am thinking:

Swim Bike Run Total
1:30 3:35 2:20 7:25

I can't seem to convice Excel 2007 to format the time I entered as an amount
of time vs. an actual time.

Any help would be appreciated.
--
Kevin
Cloverdale, BC