| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add up time
Hi
I have a coulmn that looks like this: 6:00 6:02 6:10 7:01 the duriation of time here is 1hr and 1 minute Can Excel add this up for me? Regards Gaz -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to add up time
Hi Gaz,
Format Custom as [h]:mm -- Kind regards, Niek Otten "Crowbar via OfficeKB.com" <u15117@uwe wrote in message news:5799025f9fc79@uwe... Hi I have a coulmn that looks like this: 6:00 6:02 6:10 7:01 the duriation of time here is 1hr and 1 minute Can Excel add this up for me? Regards Gaz -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to add up time
Hi Gaz
Try this:- A B 1 6:00 2 6:01 3 6:10 4 7:01 Format cells in A and B as hh:mm In B1 type =A1 and in B2 type =A2-$B$1 drag formula down. Sandy "Crowbar via OfficeKB.com" <u15117@uwe wrote in message news:5799025f9fc79@uwe... Hi I have a coulmn that looks like this: 6:00 6:02 6:10 7:01 the duriation of time here is 1hr and 1 minute Can Excel add this up for me? Regards Gaz -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to add up time
That works, Thanks
-- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Hybrid Mode
