Format Cells for Mins / Secs

C

Chris Cornell

I am Trying to format the cells to read only mins and secs. Then I would like
add them together. For example At Work our times are based on 30 minute
increments. So if we go on lunch it shows up like so.
6:30 - 7:00 8:53 (Mins/Secs)
7:00 - 7:30 23:06(Mins/Secs)

I want to be able to format the cells to enter the amount of time a person
has been on lunch and add them together. For Example:

B2 = 8:53 C2 = 23:06 =SUM(b2,c2)=31:59
 
R

Roger Govier

Hi Chris

Format the cells as Format>cells>Number>Custom> hh:mm:ss
Enter your data as 0:8:53 and 0:23:06
=SUM(B2:C2)
will give 00:31:59
 
C

Chris Cornell

Thank you, go figure it was just that simple,

Roger Govier said:
Hi Chris

Format the cells as Format>cells>Number>Custom> hh:mm:ss
Enter your data as 0:8:53 and 0:23:06
=SUM(B2:C2)
will give 00:31:59
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top