Format the sum cell

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

Guest

hello,

how can i format the cell to display the sum of some time cells like

input
10:00
30:00
20:00

Sum
60:00 <- Problem!!!! it displays only 12:00

i want something like 02:12:00 (2 days 12 hours 00 Min)

thanks

i tryed to use something - hh:mm but it displays
 
Format as [h]:mm which will cater for more than 24 hours.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
formatting with time 37:30:55 will display the corect values in hours but
not the values in a format like:
day hours:minutes...

regards
 
Hi Xavier,
formatting with time 37:30:55 will display the corect values in hours
but
not the values in a format like:
day hours:minutes...

Try the custom format:

dd hh:mm
 
i tryed something like

=TEXT(SUM(F39);"tt:hh:mm")

where SUM(F39) is 28:00 (28 hours) ..

but now i get 02:04:00 (wy 02 and not 01?)

thanks
 
i tryed with

=TEXT(SUM(F39);"tt:hh:mm")
or
=TEXT(SUM(F39);"tt hh:mm")
because it is a german version instead of dd .....

but it displays a wrong value

for 28 hours it displays 02 04:00

any ideas?
thanks
 
Hi Xavier,

Why not simply select the sum cell and custom format it as suggested?

Format | Cells | Custom | dd hh:mm

Obviously, you will need to adjust this to accord with your German version
of Excel.

Incidentally, using your Text function worked for me with the indicated
data.
 
hello Norman
you have right (i did not know this ....) ... but:

i use a 1904 Date System ... becaus i have to display also negative minutes
....

If i format the sum of times with a value for example 17:00 ( 17 hours)
and i change the format to d hh:mm it displays

1 17:30 and not 0 17:30

any ideas ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top