Warning: Trying to access array offset on value of type null in /www/wwwroot/app-pack.telkomuniversity.ac.id/wp-content/themes/sinrato/functions.php on line 40
Re: Excel formula
I’m trying to do something really simple, but seem to be struggling.Working on a timesheet template.A1=Start Time 08:00, A2=Finish Time 17:00, A3 = Hours Worked 09:00.In cell A4 I am trying to show standard hours <=08:00, however all of the formulas I seem to try come up with errors or do not work, or it just comes up with a count i.e. 1, not the hours.Tried COUNTIF and various others.Help! I’m trying to do something really simple, but seem to be struggling.
Working on a timesheet template.
A1=Start Time 08:00, A2=Finish Time 17:00, A3 = Hours Worked 09:00.
In cell A4 I am trying to show standard hours <=08:00, however all of the formulas I seem to try come up with errors or do not work, or it just comes up with a count i.e. 1, not the hours.
Tried COUNTIF and various others.
Help!
