ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help! (https://www.excelbanter.com/excel-discussion-misc-queries/78546-help.html)

OSSIE

Help!
 

what i need to know its how many hours the person worked i mean like if
they came in 6 am the shift ends 2:30 pm and the next cell would have
the answer as 8 hrs takeing out the half hour for lunch or for my night
shift they come in at 14:00 and dont leave till 10:30 that woudl give me
again the 8 hrs or whaterver hours they work hope i explain better
thanks


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=524613


daddylonglegs

Help!
 

If start time is in A1 and end time in B1 then to show the number of
hours worked minus 30 minutes

=MOD(B1-A1,1)-"00:30"

format as h:mm


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524613



All times are GMT +1. The time now is 07:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com