Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 441

# Excel - computing Hours and minutes question

I have a cell that has 9:30 am and need to add 40 minutes to it.  How do I do this?  If I add 40 to the cell containing 9:30 am, I get 9:30 am plus 40 days.

... I'm trying to understand time arithmetic in Excel.
0
brothertruffle880
2 Solutions

Commented:

New time = current time + Time(hours,minutes,seconds)

="9:30"+TIME(0,40,0)

.... or "9:30" could reference cell A1 for example... if cell A1 had 9:30 in it.
0

Volunteer Chief Information OfficerCommented:
What's the cell formatted?  Date?

if Date, and time is included with date:

Cheers.
0

Commented:
supposing cell a1 had 9:30 in it...

you could use the following formula : =A1+time(,0,40,0)
0

Commented:
or 0:40:00 works as well.
0

Commented:
or...

as 1 = 1 day then 1 min = (1 / 24) / 60 or 1 / 1440
so 40min =  40 / 1440

so 9:30 + (40 / 1440) will do it.
0

Commented:
Another way is to add a time value in quotes, to add 40 minutes to A1

=A1+"0:40"

regards, barry
0

Volunteer Chief Information OfficerCommented:
Sorry, I just wanted to point out the DateAdd function does work for minutes and seconds, if the cells are set to Date format.