elapsed time

[Sweetpea60]

I am trying to add a column of time. It should be simple but I cannot get it
to work.

Thanks,
Patti

 

[JE McGimpsey]

Times are stored by XL as fractional days, so you can simply add them,
or use the SUM() function.

By default, displayed times roll over at 24 hours. To prevent that,
choose Format/Cell/Number/Custom and enter

[h]:mm:ss

in the format box.

 

[Sweetpea60]

I've tried both of those things and it doesn't seem to work. Sometimes it
will give me a total but the total is not correct.

Thanks

Times are stored by XL as fractional days, so you can simply add them,
or use the SUM() function.

By default, displayed times roll over at 24 hours. To prevent that,
choose Format/Cell/Number/Custom and enter

[h]:mm:ss

in the format box.

I am trying to add a column of time. It should be simple but I cannot get it
to work.

 

[Peo Sjoblom]

Then some of your times are text

--

Regards,

Peo Sjoblom

I've tried both of those things and it doesn't seem to work. Sometimes it
will give me a total but the total is not correct.

Thanks

Times are stored by XL as fractional days, so you can simply add them,
or use the SUM() function.

By default, displayed times roll over at 24 hours. To prevent that,
choose Format/Cell/Number/Custom and enter

[h]:mm:ss

in the format box.

I am trying to add a column of time. It should be simple but I cannot get it
to work.

 

[Sweetpea60]

I put =TIME() in every cell. Why does Excel think it is text? And how do I
change it?

This is just a column of hours that I am trying to sum.

Thanks,

Patti

Then some of your times are text

--

Regards,

Peo Sjoblom

I've tried both of those things and it doesn't seem to work. Sometimes it
will give me a total but the total is not correct.

Thanks

Times are stored by XL as fractional days, so you can simply add them,
or use the SUM() function.

By default, displayed times roll over at 24 hours. To prevent that,
choose Format/Cell/Number/Custom and enter

[h]:mm:ss

in the format box.



I am trying to add a column of time. It should be simple but I cannot get it
to work.

 

[Peo Sjoblom]

Why do you put TIME there? One way although you might have to reformat as
times again hh:mm or something like that

copy an empty cell, select the time range, do edit>paste special and select
add
also when totalling the time use [hh]:mm as format or it will start over
after 24 hours (meaning 30:00 will display as 06:00)


--

Regards,

Peo Sjoblom

I put =TIME() in every cell. Why does Excel think it is text? And how do I
change it?

This is just a column of hours that I am trying to sum.

Thanks,

Patti

Then some of your times are text

--

Regards,

Peo Sjoblom

I've tried both of those things and it doesn't seem to work. Sometimes it
will give me a total but the total is not correct.

Thanks

:

Times are stored by XL as fractional days, so you can simply add them,
or use the SUM() function.

By default, displayed times roll over at 24 hours. To prevent that,
choose Format/Cell/Number/Custom and enter

[h]:mm:ss

in the format box.



I am trying to add a column of time. It should be simple but I

cannot
get it

to work.

 

[Sweetpea60]

Peo,

Well, I'll be darned. It worked! Thanks so much.

Patti

Why do you put TIME there? One way although you might have to reformat as
times again hh:mm or something like that

copy an empty cell, select the time range, do edit>paste special and select
add
also when totalling the time use [hh]:mm as format or it will start over
after 24 hours (meaning 30:00 will display as 06:00)


--

Regards,

Peo Sjoblom

I put =TIME() in every cell. Why does Excel think it is text? And how do I
change it?

This is just a column of hours that I am trying to sum.

Thanks,

Patti

Then some of your times are text

--

Regards,

Peo Sjoblom


I've tried both of those things and it doesn't seem to work. Sometimes it
will give me a total but the total is not correct.

Thanks

:

Times are stored by XL as fractional days, so you can simply add them,
or use the SUM() function.

By default, displayed times roll over at 24 hours. To prevent that,
choose Format/Cell/Number/Custom and enter

[h]:mm:ss

in the format box.



I am trying to add a column of time. It should be simple but I cannot
get it
to work.