Total work hours as if it were a Time Clock

[vinnievegas]

A1 through A7 is the time I clock in every day (EXAMPLE: 11:00 PM)
B1 through B7 is the time I clock out every day (EXAMPLE: 7:00 AM)
D1 through D7 is the colum that will display the total hours for each
day of the week.
What Time format do I use for the cells A1 through A7, and B1 through
B7?
and what formula do I use on cells D1 through D7 to calculate the total
hours for each day?

 

[Biff]

Hi!

You can use just about any time format you want. What's wrong with using the
format in your example?

If you type in 11:00 PM Excel automatically recognizes that as a time and
there is no need to apply a TIME format. You could use a 24 hour clock
format like 23:00 and then you wouldn't have to enter the AM/PM

So.....

A1 = either 11:00 PM or 23:00
B1 = either 7:00 AM or 7:00

Formula in D1 if you want the result displayed as - 8:00 - format the cell
as h:mm

=B1-A1+(B1<A1)

If you want the result as a decimal - 8 - use this formula:

=(B1-A1+(B1<A1))*24

Copy down to D7

Biff

"vinnievegas" <[email protected]>
wrote in message
news:[email protected]...