how to add times from decimal to time?

A

aidomatic

need to find out fow to addd time that is in decimal format and desplay the
answer in time for example
1.5+1.5= 2min & 30sec
 
F

Frank Kabel

Hi
one way:
=A1/24+A2/24
and format the resulting cell as 'Time' opr the custom format
[hh]:mm
 
J

Jerry W. Lewis

In Excel, times are decimal fractions of a day that are simply formatted
to look like time. Thus =2.5/24/60 when formatted as time displays as
0:02:30 (2 minutes and 30 seconds).

However I can't figure out what what you are trying to do in your
example. What is the .5 in 1.5 supposed to represent? If it is one and
a half minutes, then 1.5+1.5 is 3 minutes, not 2 minutes and 30 seconds.

Jerry
 
Top