ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I calculate times in seconds and minutes using percentages (https://www.excelbanter.com/excel-worksheet-functions/88016-how-do-i-calculate-times-seconds-minutes-using-percentages.html)

Lost for time

how do I calculate times in seconds and minutes using percentages
 
I work with equipment that has to run in seconds and minutes at a time and
would like to show the increase in Inq. of 15 % at a time. I have to start
with 35 second and run the increase about 35 times in a day could anyone
help? I am stumped. this has to show on the screen in minutes and seconds.

Fred Smith

how do I calculate times in seconds and minutes using percentages
 
Seems simple to me, so I might be missing something. Starting at A1 for example,
enter:

A1: 00:00:35 -format as mm:ss
A2: =A1*1.15

and copy down 34 times.

--
Regards,
Fred


"Lost for time" <Lost for wrote in message
...
I work with equipment that has to run in seconds and minutes at a time and
would like to show the increase in Inq. of 15 % at a time. I have to start
with 35 second and run the increase about 35 times in a day could anyone
help? I am stumped. this has to show on the screen in minutes and seconds.





All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com