Adding 2.5 hours to 4:30 AM ??

  • Thread starter Thread starter boureesteve
  • Start date Start date
B

boureesteve

I have a task/calculation that results in 2.5 hours to
complete. How I can I add those hours to the time 4:30 to
obtain a result of 7:00 ?
a1= 4:30
a2= 2.5
a1+a2 results in 2.69 in general format
changing it to time format = 16:30
Also, is there an easy way to get the .5 (hours)to
show :30 (minutes) in my calculations ?

Thanks,
 
Time is stored in Excel as a fraction of one day. So to add decimal hours,
you have to divide them by 24
=A1+(A2/24)
again ensure it is in time format.

To show the .5 hours as :30, enter as 2:30 and it will then be time (and you
won't need to divide by 24).
 
It must be way too early for me today !!!
Now the following is producing #value!
a1 = :30
a2 = :36
I need a2-a1 to result in :06
but I'm getting #value!
What am I doing wrong ?

Thanks,

Steve
 
Back
Top