Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old December 2nd 16, 04:07 PM
Banned
 
First recorded activity by ExcelBanter: Dec 2016
Posts: 11
Default

Quote:
Originally Posted by KJ7 View Post
I've got a template I'm using (in Excel 2003) where I need to subtract two time-based fields from one another. (Seems simple enough). However... this is for use @ a small post production co., where the smallest unit of measure is not actually the more commonly referenced 'second', but rather - the 'frame' (generally at the rate of 24 or 30 frames per second). What I'd like to accomplish is this: a formula that takes the two timecodes and subtracts in from out... leaving me with a duration: EX: 01:11:27.03 - 01:11:23.20 = 00:00:03.13 (or 3 sec & 13 frames) thanks for your help. ~kj
It is actually a nice and useful piece of information. I'm satisfied that you simply shared this helpful info with us. Please keep us up to date like this. Thanks for sharing.

  #12   Report Post  
Old December 3rd 16, 03:09 AM
Banned
 
First recorded activity by ExcelBanter: Dec 2016
Posts: 11
Default

Quote:
Originally Posted by KJ7 View Post
I've got a template I'm using (in Excel 2003) where I need to subtract two time-based fields from one another. (Seems simple enough). However... this is for use @ a small post production co., where the smallest unit of measure is not actually the more commonly referenced 'second', but rather - the 'frame' (generally at the rate of 24 or 30 frames per second). What I'd like to accomplish is this: a formula that takes the two timecodes and subtracts in from out... leaving me with a duration: EX: 01:11:27.03 - 01:11:23.20 = 00:00:03.13 (or 3 sec & 13 frames) thanks for your help. ~kj
Great article. I'm dealing with many of these issues as well..
  #13   Report Post  
Old December 3rd 16, 04:06 AM
Banned
 
First recorded activity by ExcelBanter: Dec 2016
Posts: 11
Default

Quote:
Originally Posted by KJ7 View Post
I've got a template I'm using (in Excel 2003) where I need to subtract two time-based fields from one another. (Seems simple enough). However... this is for use @ a small post production co., where the smallest unit of measure is not actually the more commonly referenced 'second', but rather - the 'frame' (generally at the rate of 24 or 30 frames per second). What I'd like to accomplish is this: a formula that takes the two timecodes and subtracts in from out... leaving me with a duration: EX: 01:11:27.03 - 01:11:23.20 = 00:00:03.13 (or 3 sec & 13 frames) thanks for your help. ~kj
I loved as much as you'll receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get got an nervousness over that you wish be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly very often inside case you shield this increase.
  #14   Report Post  
Old December 3rd 16, 06:06 AM
Banned
 
First recorded activity by ExcelBanter: Dec 2016
Posts: 11
Default

Quote:
Originally Posted by KJ7 View Post
I've got a template I'm using (in Excel 2003) where I need to subtract two time-based fields from one another. (Seems simple enough). However... this is for use @ a small post production co., where the smallest unit of measure is not actually the more commonly referenced 'second', but rather - the 'frame' (generally at the rate of 24 or 30 frames per second). What I'd like to accomplish is this: a formula that takes the two timecodes and subtracts in from out... leaving me with a duration: EX: 01:11:27.03 - 01:11:23.20 = 00:00:03.13 (or 3 sec & 13 frames) thanks for your help. ~kj
I dugg some of you post as I thought they were very useful extremely helpful.
  #15   Report Post  
Old December 3rd 16, 10:03 AM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2016
Posts: 3
Default

Quote:
Originally Posted by KJ7 View Post
I've got a template I'm using (in Excel 2003) where I need to subtract two time-based fields from one another. (Seems simple enough). However... this is for use @ a small post production co., where the smallest unit of measure is not actually the more commonly referenced 'second', but rather - the 'frame' (generally at the rate of 24 or 30 frames per second). What I'd like to accomplish is this: a formula that takes the two timecodes and subtracts in from out... leaving me with a duration: EX: 01:11:27.03 - 01:11:23.20 = 00:00:03.13 (or 3 sec & 13 frames) thanks for your help. ~kj
Để giải tỏa khúc mắc cho câu hỏi trên, thứ nhất hãy chung Chevrolet Phú Mỹ Hưng hồi cứu lại “quê quán” của mẫu xe n*y. dòng xe Chevrolet sản xuất ở Mỹ. Người Mỹ luôn luôn quan tâm tiêu ch* an to*n v* sự dẻo dai đặt lên b*c nhất. - See more :http://www.giaxeotovn.xyz/


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Help with Freezing/Splitting 2 Frames in Excel 2003 Tyn Excel Discussion (Misc queries) 3 February 13th 07 06:19 PM
Frames in Excel with drop down boxes. Adam Excel Discussion (Misc queries) 2 December 31st 06 04:53 PM
freezing frames Bob Griendling Excel Worksheet Functions 4 July 1st 06 10:58 PM
Calculation of Hrs and Mins from 2 Time Frames Corey Excel Worksheet Functions 6 May 31st 06 05:12 PM
how do I add/subtract time when I'm going from PM to AM (ex. 11:4. tammyj Excel Worksheet Functions 1 March 15th 05 07:31 PM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017