#1   Report Post  
Old August 1st 19, 01:35 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2019
Posts: 2
Default Time calculation

Hi, I need to generate a quick calculator of percentage of time. For example 150% of 5min:0sec = 7min:30sec, 75% of 5min:0sec = 3min:45sec, etc.

Any help would be appreciated!

  #2   Report Post  
Old August 1st 19, 10:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 152
Default Time calculation

On Thursday, August 1, 2019 at 5:49:08 AM UTC-7, Tannruns wrote:
Hi, I need to generate a quick calculator of percentage of time. For
example 150% of 5min:0sec = 7min:30sec, 75% of 5min:0sec = 3min:45sec,


It's just multiplication. First, I custom-formatted columns A and C as
m"min:"s"sec"
Then, column B as a percentage.

Then I entered
A1: =TIME(0,5,0)
A2: =TIME(0,5,0)
B1: 150%
B2: 75%
C1: =A1*B1 and copied down to C2.

Seems to meet the need.
  #3   Report Post  
Old August 2nd 19, 02:50 AM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2019
Posts: 2
Default

Great thank you!! Iím pretty novice with this stuff, appreciate the help!!


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
Stop time - start time calculation squack21 Excel Worksheet Functions 5 December 10th 07 03:20 PM
Time calculation (Subraction of Idle Time) Ajay Excel Discussion (Misc queries) 6 March 4th 07 11:54 AM
Time Calculation Gary Excel Worksheet Functions 3 September 14th 06 06:45 PM
Ignoring Time in a Date Time Calculation nmp Excel Worksheet Functions 3 November 23rd 05 08:32 PM
time calculation with military time Ron Thetford Excel Worksheet Functions 8 July 29th 05 07:24 PM


All times are GMT +1. The time now is 02:35 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017