How to add up time
 

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

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

How to add up time
 

Hi Gaz
Try this:-
A B
1 6:00
2 6:01
3 6:10
4 7:01
Format cells in A and B as hh:mm
In B1 type =A1 and in B2 type =A2-$B$1 drag formula down.
Sandy


"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

How to add up time
 

That works, Thanks

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