Timesheets

[SilviaG]

When having a timesheet in an excel spreadsheet how can i convert the time
worked for example an 8 hour work day with 30 min into 8.5 to use for payroll?

 

[Gaurav]

if you have 8:30 in A1....type the following formula where you need 8.5

=A1*24