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

=A1*24

"SilviaG" wrote in message
...
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?