| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Figuring out hours worked
In cell F3 I am trying to get the hours work from the start time in cell D3
and the finish time in E3. I can not locate the forulma for this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Figuring out hours worked
You can subtract the start time from the end time and then multiply
the difference by 24. E.g., =(E3-D3)*24 If it is possible that the start time is greater than the end time (e.g., crossing Midnight, start and 10PM and end at 3AM) use formula like the following: =(E3-D3+(D3E3))*24 Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 20 May 2009 14:08:00 -0700, Matt wrote: In cell F3 I am trying to get the hours work from the start time in cell D3 and the finish time in E3. I can not locate the forulma for this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Figuring out hours worked
Try one of these:
=IF(COUNT(D3:E3)=2,E3-D3,"") If the end time might span past midnight: =IF(COUNT(D3:E3)=2,MOD(E3-D3,1),"") Format as h:mm -- Biff Microsoft Excel MVP "Matt" wrote in message ... In cell F3 I am trying to get the hours work from the start time in cell D3 and the finish time in E3. I can not locate the forulma for this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Figuring out hours worked
That worked thanks alot
"Chip Pearson" wrote: You can subtract the start time from the end time and then multiply the difference by 24. E.g., =(E3-D3)*24 If it is possible that the start time is greater than the end time (e.g., crossing Midnight, start and 10PM and end at 3AM) use formula like the following: =(E3-D3+(D3E3))*24 Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 20 May 2009 14:08:00 -0700, Matt wrote: In cell F3 I am trying to get the hours work from the start time in cell D3 and the finish time in E3. I can not locate the forulma for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Millitary Time to Hours worked and OT hours | Excel Worksheet Functions | |||
| wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| Figuring hours | Excel Worksheet Functions | |||
| Figuring hours | Excel Worksheet Functions | |||
Linear Mode
