Adding hours and minutes in a column

[Guest]

=TEXT(B9-A9,"h:mm") This is the formula I'm using to record the down time.
What can I use to add up the column for a total hrs and minutes?
We might run 24 hrs for a whole week.

Any help would be appreciated,

Fly Boy 5

 

[Fred Smith]

You can do arithmetic on times, but not text. If you want to do arithmetic, then
don't convert to text.

1. Change your formula to: =b9-a9
2. Format as h:mm
3. Now you can add the column. If the column can total more than 24 hours, use a
format of [hh]:mm

 

[Guest]

Thanks Fred,

It work fine!!!!!!!!!

You can do arithmetic on times, but not text. If you want to do arithmetic, then
don't convert to text.

1. Change your formula to: =b9-a9
2. Format as h:mm
3. Now you can add the column. If the column can total more than 24 hours, use a
format of [hh]:mm

--
Regards,
Fred

=TEXT(B9-A9,"h:mm") This is the formula I'm using to record the down time.
What can I use to add up the column for a total hrs and minutes?
We might run 24 hrs for a whole week.

Any help would be appreciated,

Fly Boy 5

 

[Fred Smith]

Glad to help. Thanks for the feedback.

--
Regards,
Fred

Thanks Fred,

It work fine!!!!!!!!!

You can do arithmetic on times, but not text. If you want to do arithmetic,
then
don't convert to text.

1. Change your formula to: =b9-a9
2. Format as h:mm
3. Now you can add the column. If the column can total more than 24 hours,
use a
format of [hh]:mm

--
Regards,
Fred

=TEXT(B9-A9,"h:mm") This is the formula I'm using to record the down time.
What can I use to add up the column for a total hrs and minutes?
We might run 24 hrs for a whole week.

Any help would be appreciated,

Fly Boy 5