Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i calculate a work schedule in excel? | Excel Discussion (Misc queries) | |||
calculate price * quantity = total amount in a row of excel forml. | Excel Worksheet Functions | |||
Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
Has anyone built an Excel spreadsheet to calculate churn? | Excel Discussion (Misc queries) |