If Functions calculating time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope this makes some senc
START TRAVEL WORK REST WORK TRAVEL FINISH TOTAL X1 0/
TIME
C13 G13 J1
7:30 0:00 8:00 3:00 21:30 0:30 23:00 12:30 0:0
Travel can not be >01:0

If c13 is <=01:00 hh:mm the result in j13 should be the value of c13 added to the result in g13, if the value of c13 is > 01:00 the value returned j13 should not be >01:00 plus the value of g13 (the result of c13 needs added to g13 and vice versa

If g13 is <=01:00 hh:mm the result in j13 should be the value of g13 added to the result in c13 if the value of g13 is > 01:00 the value returned j13 should not be >01:00 plus the value of c13 (the result of g13 needs added to c13 and vice versa

the result of both c13 and g13 need to be added to give a combined result in j1

I have used C1 as a sacrificial cell

IF(C13<=$C$1,SUM(C13),IF(C13>=$C$1,SUM(C1),IF(G13>=$C$1,SUM(G13)*IF(G13>=$C$1,SUM(C1),IF(C13&G13<=$C$1,SUM(C13+G13)))))

Hope you can hel
 
Hi andy
not so sure about your expected result. Do you want to add C13 and G13
(but only a max. of 1:00 for each cell). This would be
=MIN(C13,1/24)+MIN(G13,1/24)

Or does the combined result in J13 not exceed 1:00. Then use
=MIN(C13+G13,1/24)


--
Regards
Frank Kabel
Frankfurt, Germany
 
Back
Top