Not understanding how to enter a formula

P

Paul A.

needs a formula that will subtract/add hours and minutes

i.e, 0:55
7:15
7:15
0:17
0:25
4:25
7:15

Could you please advise.

Thanks,

Paul
 
M

Mark Graesser

Paul,
As long as the cells are formatted properly you can just use +. If you want to get a total showing hours and minutes you will need to set a custom number format of:

[h]:mm

The standard time formats will roll back to zero when you reach 24.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Paul A. wrote: -----

needs a formula that will subtract/add hours and minutes

i.e, 0:55
7:15
7:15
0:17
0:25
4:25
7:15

Could you please advise.

Thanks,

Paul
 
B

Bob Phillips

When you subtract though, be careful, you can't go negative as it shows as
all ####, so you need to code around it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Mark Graesser said:
Paul,
As long as the cells are formatted properly you can just use +. If you
want to get a total showing hours and minutes you will need to set a custom
number format of:
[h]:mm

The standard time formats will roll back to zero when you reach 24.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Paul A. wrote: -----

needs a formula that will subtract/add hours and minutes

i.e, 0:55
7:15
7:15
0:17
0:25
4:25
7:15

Could you please advise.

Thanks,

Paul
 

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

Top