2400 hour function required

  • Thread starter Thread starter sanmarco
  • Start date Start date
S

sanmarco

Hello to everyone,

I hope someone would be kind enough to help me with this one.

When using 2400 hour format I am trying to create formulas which will
act as follows:

1. H5= E10-D10-30 IF GREATER THAN 0830

2. IF H5 IS GREATER THAN 0125 THEN BOTH N5 AND O5 = 1

3. IF H5 IS GREATER THAN 0230 THEN I5 = H5-0230

Thanking you in anticipation
 
You are not using 24 format if you don't use a time delimiter excel can
interpret
if you use 2215 for 22:15 that means it is interpreted as 2 thousand 2
hundred 15
There are formulas that can make it time but I'd suggest you use a time
format

Secondly formulas can only change values in the cells that hold the
formulas, so to change
H5, I5 and O5 you would need either a macro or formulas in those cells.

=IF(H5>TIME(8,30,),E10-D10-30,"not greater than 08:30")

That should show you how to proceed with the other cells

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
Thank you for your advice, however this did not work.
what I am trying to achieve here is:
Where E10 is 06:00 and D10 is 17:00 less half hour the result i
greater than 8.5 hours. H5 then should = 2 hour
 
Back
Top