| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Time from another Worksheet
Hello from Steved
I would like to Sum "Time" ie 8:30 + 8:01 and so on from another column "SS OLD" from W3:W35 please How do I go about this please. Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum Time from another Worksheet
Try this"
=SUM('SS OLD'!W3:W35) Format as [h]:mm Biff "Steved" wrote in message ... Hello from Steved I would like to Sum "Time" ie 8:30 + 8:01 and so on from another column "SS OLD" from W3:W35 please How do I go about this please. Thankyou. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum Time from another Worksheet
Thankyou.
"T. Valko" wrote: Try this" =SUM('SS OLD'!W3:W35) Format as [h]:mm Biff "Steved" wrote in message ... Hello from Steved I would like to Sum "Time" ie 8:30 + 8:01 and so on from another column "SS OLD" from W3:W35 please How do I go about this please. Thankyou. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum Time from another Worksheet
You're welcome!
Biff "Steved" wrote in message ... Thankyou. "T. Valko" wrote: Try this" =SUM('SS OLD'!W3:W35) Format as [h]:mm Biff "Steved" wrote in message ... Hello from Steved I would like to Sum "Time" ie 8:30 + 8:01 and so on from another column "SS OLD" from W3:W35 please How do I go about this please. Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying more that one Worksheet at a time. | Excel Discussion (Misc queries) | |||
| Real time in worksheet | Excel Worksheet Functions | |||
| Swap to another worksheet after given time | Excel Discussion (Misc queries) | |||
| Have a worksheet = cell value (Time!B2 vs C2!B2 when C2 = Time)? | Excel Worksheet Functions | |||
| Unhide more than one worksheet at a time | Excel Discussion (Misc queries) | |||
Hybrid Mode
