Calculating Time

[Jazz]

Hello,

I know there have been other posts on this subject, but I can't find
anything that answers the question that I have. I'm working on a time
card spreadsheet. The format is as follows...

E7 Time in / F7 Time Out Lunch / G7 Time In Lunch / H7 Out

I've been able to get the total time for each day to work in time
format by using the following.


Code:
--------------------
=F7-E7+H7-G7
--------------------


Where I'm having trouble is that I'd like to add the total for each day
to accumulate in cell D21 in decimal format, so that 8:30 will appear as
8.5.

Is there any way to do this?

Thanks for nyour help!

 

[Chip Pearson]

Multiply your result time by 24.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


in message
news:[email protected]...

 

[Mallycat]

Where I'm having trouble is that I'd like to add the total for each day
to accumulate in cell D21 in decimal format, so that 8:30 will appear as
8.5.

Is there any way to do this?
QUOTE]

The way to do it is to use the MINUTE and HOUR functions.
=HOUR(8:30) + MINUTE(8:30)/60 will give you 8.5

EDIT: if you have previously had time formatted data in a cell, make
sure you reformat the cell to GENERAL or else you wont see the time
displayed properly.

Matt

 

[Jazz]

Thanks for your help! Both suggestions work great!