Forum Discussion
Janice Dodge
Nov 09, 2018Copper Contributor
HELP!! w creating a specific formula
Hi, BACKSTORY IN CASE YOU NEED IT. I am working on a spreadsheet I created to tally up payroll. I am great at creating spreadsheets. Pretty good at knowing formula options for most needs. BUT I am...
JKPieterse
Nov 12, 2018Silver Contributor
It is easier if you put your sample data into a small Excel file and upload that, along with some rules as to how we should calculate the # of hours (it is not clear to me how you arrived at the 4 hrs and 1.5 hrs in your example above, starting from the 9.25 and 4.25 hours in A and B)