View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How to add up time

Hi Gaz,

Format Custom as [h]:mm

--
Kind regards,

Niek Otten

"Crowbar via OfficeKB.com" <u15117@uwe wrote in message
news:5799025f9fc79@uwe...
Hi

I have a coulmn that looks like this:

6:00
6:02
6:10
7:01

the duriation of time here is 1hr and 1 minute

Can Excel add this up for me?

Regards
Gaz

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1