excel-hrs spreadsheet-work 8:15 - 5:30 (how calculate total hrs?)
 

I am trying to create a database that will show how many hours I work per day
/ per week. I want to put in the time I begin work (example - 8:15) and the
time I leave (example 5:45) and have it show that I worked 9.5 hours. I've
tried military time, I've tried formatting time as numbers. Can't get it to
work with the 60 minutes per hour. Any suggestions on how to do this?

excel-hrs spreadsheet-work 8:15 - 5:30 (how calculate total hrs?)
 

one way to try where m12 is the start and m13 is the end

=(M13-M12+IF(M13<M12,0.5))*24

--
Don Guillett
SalesAid Software

"Harris" wrote in message
...
I am trying to create a database that will show how many hours I work per
day
/ per week. I want to put in the time I begin work (example - 8:15) and
the
time I leave (example 5:45) and have it show that I worked 9.5 hours.
I've
tried military time, I've tried formatting time as numbers. Can't get it
to
work with the 60 minutes per hour. Any suggestions on how to do this?

excel-hrs spreadsheet-work 8:15 - 5:30 (how calculate total hrs?)
 

please use this reference:

http://cpearson.com/excel/distribdates.htm

They have the perfect decision for you.


--
Irina
------------------------------------------------------------------------
Irina's Profile: http://www.excelforum.com/member.php...fo&userid=8685
View this thread: http://www.excelforum.com/showthread...hreadid=522383