FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,364
- Office Version
- 365
- 2016
- Platform
- Windows
I have some ppt recordings and just need to time the slides with a total.
Example:
column Q is the number I get from ppt, and column R is what the value is in mm:ss. Column S is what I would like. As you can see, I'm always rounding up.
I'm doing all of this in Excel.
Example:
Book1 | |||||
---|---|---|---|---|---|
Q | R | S | |||
2 | 181162 | 0:03:01.16 | 0:03:02 | ||
3 | 11626 | 0:00:11.63 | 0:00:12 | ||
4 | 70869 | 0:01:10.87 | 0:01:11 | ||
5 | 5354 | 0:00:05.35 | 0:00:06 | ||
Sheet1 |
column Q is the number I get from ppt, and column R is what the value is in mm:ss. Column S is what I would like. As you can see, I'm always rounding up.
I'm doing all of this in Excel.