# Re: Hours calculation in 24h format

thank for the answer, it was exactily what i wanted.

Ana Paula

"Sandy Mann" escreveu:

Ana,

Custom Format the cell as [h]:mm

the square brackets will stop the hours rolling over into days when they gat
to 24

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@xxxxxxxxxxxxxx
Replace@xxxxxxxxxxxxxx with @tiscali.co.uk

"Ana Paula" <Ana Paula@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29DA43BD-5517-4007-B99C-3FBF1E888989@xxxxxxxxxxxxxxxx
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" <lmc@xxxxxxx> escreveu na mensagem
news:e\$i2IY01GHA.2176@xxxxxxxxxxxxxxxxxxxxxxx
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" <lmc@xxxxxxx> a écrit dans le message de news:
%23hr2uI01GHA.4116@xxxxxxxxxxxxxxxxxxxxxxx
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

LMC

.

## Relevant Pages

• Re: Hours calculation in 24h format
... Custom Format the cell as:mm ... I now that my demand has been n demanded times and every time that we ... arrival 13:30h, Cell A4 departure 18:45h ...
(microsoft.public.excel.misc)
• Re: Excel 2007: @*. formatting
... I've used a custom format of: ... As soon as I shrink the columnwidth so that the text won't fit in the cell (when ... "Dave Peterson" wrote: ... But MS has known about the length of the string and the cell formatted as text ...
(microsoft.public.excel.misc)
• Re: Auto insert Unit of Measure
... just use a custom format. ... MB) automatically by just inputing a value in the cell (even tho 1 GB ... I tried inputing the above formula to excel conditional formatting... ... Is the only way to get the above result by inputting some VBA code? ...
(microsoft.public.excel)
• Re: Filter question
... "Bg" escreveu: ... etc. Have auto-filters applied and want to have the subtotals ... I have displayed the sub-totals in cell ...
(microsoft.public.excel.worksheet.functions)
• Re: Change a specific figure i.e 0:00 and 24:00 to display as "MID
... You can display 0:00:00 as "MIDT" using a custom format of ... You can use custom formatting to check for values less than or greater than certain values, but it will only highlight the cell, not display an error message. ... word "MIDT". ...
(microsoft.public.excel.misc)