Calculating hours worked in a day

[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

 

[Patrick BASTARD]

Bonjour, *Jaz*


the time they came in in E6 (19:50) format, hh:mm
the time they went home in F6 (5:15) format, hh:mm

=MOD(F6-E6;1)/"1:" Format, standard gives 9.42

 

[Peo Sjoblom]

=ROUND((B1-A1)*24,2)

where B1 is end time and A1 start

Format as general

 

[Guest]

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