| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format Cells for Mins / Secs
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Format Cells for Mins / Secs
Hi Chris
Format the cells as FormatcellsNumberCustom hh:mm:ss Enter your data as 0:8:53 and 0:23:06 =SUM(B2:C2) will give 00:31:59 -- Regards Roger Govier "Chris Cornell" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Format Cells for Mins / Secs
Thank you, go figure it was just that simple,
"Roger Govier" wrote: Hi Chris Format the cells as FormatcellsNumberCustom hh:mm:ss Enter your data as 0:8:53 and 0:23:06 =SUM(B2:C2) will give 00:31:59 -- Regards Roger Govier "Chris Cornell" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i convert a value quoted in hrs,mins,secs to just mins | Excel Worksheet Functions | |||
| Importing Mins:Secs | Excel Discussion (Misc queries) | |||
| How do I set cells to sum/average/etc time? e.g. 1 minute 30 secs | Excel Worksheet Functions | |||
| How can I calculate a value using time duration in mins & secs | Excel Worksheet Functions | |||
| Convert mins:secs to seconds only | Excel Worksheet Functions | |||
Linear Mode
