dd:hh:mm help

M

MIVELD

Hi, I am trying to sum the time nneded to allocate people for trainin
an each course has a time set in hh:mm, when i sum them they will onl
display properly in DD:MM:HH as the training will exceed 24hrs fo
most.

I wantied to display this in just HH:MM,

Any ideas, If i leave the format on HH:MM it just forgets about th
whole days

Please hel
 
S

Stphn

I too am using dd:hh:mm in a spreedsheet I am designing, if you right
click and go to 'Format cell' and click 'custom' about half way down
you will see 'hh:mm' that is how it will be displayed in the cell in
question but in the formula box it will read dd:hh:mm

I hope this what you were looking for and it was not a lesson in
sucking eggs for you

Stephen - Stphn
 
M

mangesh_yadav

If you don't want to perform any further calculations on the result
then you can use the following.

Suppose you have calculated your sum in cell A10, then display th
result as hh:mm in A11 by entering the formula in A11:
=INT(A10*24)&":"&MOD(A10*24,1)*60

This is converted to text and displayed. For further calculations, us
your result in A10.

Manges
 
R

Ron Rosenfeld

Hi, I am trying to sum the time nneded to allocate people for training
an each course has a time set in hh:mm, when i sum them they will only
display properly in DD:MM:HH as the training will exceed 24hrs for
most.

I wantied to display this in just HH:MM,

Any ideas, If i leave the format on HH:MM it just forgets about the
whole days

Please help
Click to expand...

Use the format: [h]:mm or [hh]:mm The brackets keep the hour from rolling
over every 24.


--ron
 
Top