Not understanding how to enter a formula

  • Thread starter Thread starter Paul A.
  • Start date Start date
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
 
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
 
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
Click to expand...
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
Click to expand...
 
Back
Top