Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making calculations with times.
I'm currently creating a Physical Fitness Test roster for my work. I'm making
it to where as you fill in the information, it automatically puts the point values into the corresponding cell. I have three categories: Pullups, Crunches, 3-Mile Run. I have the Pullups and the Crunches completed. Those were no problem. Simple calculations. However, with the 3 mile run, I am having trouble finding the correct function for what I need. The times will range from under 18:00 to 33:00. 18:00 and under run time will result in 100 points, whereas 33:00 run time will result in 10 points, and over 33:00 will result in 0. The full list can be found at http://usmilitary.about.com/od/marines/l/blfitmale.htm . What I want is when I type the time into cell A1, cell A2 will automatically display the correct amount of points for the run. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making calculations with times.
How about
Format rows 1 and 4: time HH:MM:SS A4:C4 is 0:0:0 0:18:01 0:33:01 A5:C5 is 100 10 0 A2 is =HLOOKUP(A1,$A4:$C5,2,TRUE) Then entering a time in A1 (B1 ..) gives the score in A2 (B2 ..) D-C Darryl wrote: I'm currently creating a Physical Fitness Test roster for my work. I'm making it to where as you fill in the information, it automatically puts the point values into the corresponding cell. I have three categories: Pullups, Crunches, 3-Mile Run. I have the Pullups and the Crunches completed. Those were no problem. Simple calculations. However, with the 3 mile run, I am having trouble finding the correct function for what I need. The times will range from under 18:00 to 33:00. 18:00 and under run time will result in 100 points, whereas 33:00 run time will result in 10 points, and over 33:00 will result in 0. The full list can be found at http://usmilitary.about.com/od/marines/l/blfitmale.htm . What I want is when I type the time into cell A1, cell A2 will automatically display the correct amount of points for the run. Thank you. ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format for making date calculations | Excel Worksheet Functions | |||
Calculations on Times Formatted as Text | Excel Discussion (Misc queries) | |||
times and Calculations | New Users to Excel | |||
making daily calculations | Excel Discussion (Misc queries) | |||
Difference in dates calculations except between certain times. | Excel Discussion (Misc queries) |