Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I calculate percentage from seconds?
Hello:
Relatively new to excell.. so prob a easy question for most. But here goes! I would like to get the percentage of seconds lets say in an hour which would be 3600 seconds. So if A1 has the total number of seconds expected to work and in A2 was the actual number of seconds worked. Lets say I wanted to have the percentage of time worked in A3 example 80%, 75% etc. I know how to figure out the seconds just not how to have the percent total show in A3 or what time was actually done. Hope you can understand this. Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate average given minutes and seconds | Excel Discussion (Misc queries) | |||
Calculate the number of seconds between two times | Excel Worksheet Functions | |||
Calculate call cost in seconds | Excel Worksheet Functions | |||
how do I calculate times in seconds and minutes using percentages | Excel Worksheet Functions | |||
HOW TO CALCULATE HOURS WITH MINUTES AND SECONDS? | Excel Discussion (Misc queries) |