Calculating hours worked in a day

J

Jaz

I'm trying to create a time sheet for employees to enter their daily time.

I want them to put in the time they came in (ex. 7:50 AM), and the time they
went home (5:15 PM). I want a to be able to calculate the number of hours
worked. In this case it would be 9.42 hours.

How would I be able to do that?

Thanks,
Jasper
 
P

Peter Ellis

Say you place 5:15 PM in cell H5 and 7:50 AM in cell I5

In the cell showiing the elapsed time
1. Enter the formula =(H5-I5)*24
2. Format as some number (comma) with the indicated number of decimal places

The last step is needed as the result might show up as time format like
10:00 AM
 
Top