Hours calculation in 24h format
I have a sheet like that, but in my case I just sum to calculate the hours
worked, but when the hours get 24:00 it´s turns to 00:00 and satart again and
a can´t know the real time i worked for exemple in a week. there´s a way the
make the sum go on without start again after 24:00hours
e.g.
a1 = 13:30
a2 = 11:30
a3 = 1:00
a7=sum(a1+ a2 +a3) = 1:00
I want the result in a7 would be 25:00 hours worked
thanks
Ana Paula
"Rodrigo Ferreira" escreveu:
Other hint:
( A1 + A2 + A3 ) / "1:00"
( 3:40 + 9:56 + 2:10 )/ "1:00"
15:46/ "1:00" = 15,76667
Rodrigo Ferreira
"LMC" escreveu na mensagem
...
How can I calculate the total of all the hours and minutes like : 3:40 +
9:56 + 2:10 etc
This is the real problem because of the décimals
Thanks again for the effort
LMC
"LMC" a écrit dans le message de news:
...
Hello Everyone,
Can someone help me on this (I think little) problem?
I now that my demand has been n demanded times and every time that we
need something, it's impossible to find the right information on the net
so my question is:
I would like to calculate the time between an arrival and departure in
24h format for my work.
Example : Cell A1 arrival 9:30h, Cell A2 departure 12:30h, Cell A3
arrival 13:30h, Cell A4 departure 18:45h
Thanks for the answer
LMC
|