One way:

If your clock in and clock out are already times, don't convert to
decimal - just subtract them.

=IF(COUNT(C11:D11)<2,0,D11-C11+(D11<C11))

or

=IF(COUNT(C11:D11)<2,0,MOD(D11-C11,1))

Format the cell as a time.

In article ,
"Gina A." <Gina wrote:

I am working on a time sheet for work that is using the excel program. The
sheet has clock in and clock out times in several different cells. I am
trying to get the cell at the end of the row to display the amount of time
work in hours and minutes, not decimal. For instance it says 0.00 hours
instead 0:00. I am using a template that currently uses a formula as follows
to calculate the time:
=IF((OR(D11='''',C11='''')),0,IF((D11<C11),((D11-C11)*24)+24,(D11-C11)*24))

Can someone please help me!!!! I am getting very flustered trying to figure
this out. Thank You