Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding hrs
How do you make a formula that sais that an employee started work at 4am and
finished at 1030 am i need the answer to 6.5 hrs. The problem would read say in cell a1 "0400" in cell a2 (1030) and then I want cell 3 to display the amount of hrs as 6.5 not 6.3? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding hrs
You should enter it as time and change the formats.
Input A1: 4:00 AM A2: 10:30 AM A3: 24*(A2-A1) Format A1 and A2 as hhmm and format A3 as General or as a number Result: A1: 0400 A2: 1030 A3: 6.5 "demetri" wrote: How do you make a formula that sais that an employee started work at 4am and finished at 1030 am i need the answer to 6.5 hrs. The problem would read say in cell a1 "0400" in cell a2 (1030) and then I want cell 3 to display the amount of hrs as 6.5 not 6.3? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding hrs
"Sloth" wrote: You should enter it as time and change the formats. Input A1: 4:00 AM A2: 10:30 AM A3: 24*(A2-A1) Format A1 and A2 as hhmm and format A3 as General or as a number Result: A1: 0400 A2: 1030 A3: 6.5 "demetri" wrote: How do you make a formula that sais that an employee started work at 4am and finished at 1030 am i need the answer to 6.5 hrs. The problem would read say in cell a1 "0400" in cell a2 (1030) and then I want cell 3 to display the amount of hrs as 6.5 not 6.3? Thank you! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding hrs
Try
=INT(A2/100)+MOD(A2,100)/60-INT(A1/100)+MOD(A1,100)/60 and format as general -- HTH RP (remove nothere from the email address if mailing direct) "demetri" wrote in message ... How do you make a formula that sais that an employee started work at 4am and finished at 1030 am i need the answer to 6.5 hrs. The problem would read say in cell a1 "0400" in cell a2 (1030) and then I want cell 3 to display the amount of hrs as 6.5 not 6.3? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding vertical bars to an embedded chart using VBA | Excel Discussion (Misc queries) | |||
Adding values from previous worksheets | Excel Worksheet Functions | |||
help neede with adding times | Excel Discussion (Misc queries) | |||
problem adding | Excel Discussion (Misc queries) | |||
adding cells that contain formulas that have returned error messag | Excel Worksheet Functions |