Menu

Calculate After hours

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

Claus Busch is offline

external usenet poster

Posts: 3,872

Default

Calculate After hours

Hi,

Am Tue, 1 Apr 2014 10:34:35 -0700 (PDT) schrieb :

When A is equal or greater than 00:01AM and B is equal or lesser than 11:59PM it works, Although, I'd like to use A as reference when working hours passes midnight to keep counting. Let's say someone is working from 10:00 PM to 01:00 AM, the code does not recognize the calc. The result was supposed to be 3.

then try:
=IF(B10.75,B1-0.75,IF(A1=0.75,MOD(B1-A1,1),""))

Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate Hours	[email protected]	Excel Discussion (Misc queries)	1	October 15th 08 07:33 PM
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis	Graham	Excel Discussion (Misc queries)	2	January 28th 07 08:40 PM
calculate hours	Caveman	Excel Discussion (Misc queries)	1	May 29th 06 11:52 PM
How to calculate hours?	cheryl	Excel Worksheet Functions	6	August 2nd 05 08:20 AM
calculate hours	Sunny	Excel Discussion (Misc queries)	2	February 21st 05 05:51 PM

All times are GMT +1. The time now is 02:21 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement