how to add times from decimal to time?

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

Guest

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
 
Hi
one way:
=A1/24+A2/24
and format the resulting cell as 'Time' opr the custom format
[hh]:mm
 
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
 
You must log in or register to reply here.

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

Similar Threads

Numbers displayed in the 100th decimal instead on 1,000 6
Time Calculated minus breaks & lunch 2
time question 5
Blank Cell Reference, without if statement 4
Adding Time from Name Range 2
Need Formula to Calculate Time/Overtime 2
Changing decimal time into 24 hour time and reverse 4
Time 2

Back
Top