Total work hours as if it were a Time Clock

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?

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" <vinnievegas.1rarb0_1119895532.4825@excelforum-nospam.com>
wrote in message
news:vinnievegas.1rarb0_1119895532.4825@excelforum-nospam.com...
>
> 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?
>
>
> --
> vinnievegas
> ------------------------------------------------------------------------
> vinnievegas's Profile:
> http://www.excelforum.com/member.php...o&userid=24686
> View this thread: http://www.excelforum.com/showthread...hreadid=382567
>