How can i add up my income...?

Try retyping each one with a colon instead of a dot.

Where are you that has 19.08 as a format for time? I was trying to set up a document with a localization that uses that format but I didn't find one.

Here is an example of a typical way you might approach this in Numbers.

Enter the time in and time out with the cells formatted as Date & Time:

Then you can use a simple subtraction to calculate a Duration, a special data format in Numbers that measures elapsed time, as opposed to a point in time. Using the Duration format allows Numbers to take care of complicated date math "under the hood":

The formula in D2 of the example is simply =C2−B2.

Then, to calculate earnings you can use the DUR2HOURS function to convert the Duration to a decimal number that you can then multiply by the hourly rate.

The formula in E2 of the example:

=DUR2HOURS(D2)*Table 2::$A$2

SG

travelbugs wrote:

In your formula you name the cell by letter and number, when i do this it changes it to first line of text and "invoice no" & "date" as per the first entrance in each row or column, don't know if it matters but have tried to change it, but no joy! So am i making a hash of it?

Don't give up. In Numbers > Preferences in your menu just uncheck 'Use header names as labels' and you will see references to cells as letter-number.

And make sure you are entering things that Numbers recognizes as Date & Time. Look lower left to confirm.

SG

Does your table calculate the "total hrs" by subtracting "time started" from "time finished"? From your description of the problem it sounds like you are entering the total hrs by hand.

If you are entering the value .30 into a cell that is not formatted as a duration, it is a decimal number, not a duration. If you are treating the number as "hours", the decimal number 0.3 would be 3/10 of an hour = 18 minutes. The decimal number 0.5 would be 30 minutes (1/2 an hour).

If you are using a duration format for the cell, an entry of 30m or .5h would be a duration of half an hour. If you set the top unit of the duration format to be hours, a decimal entry of 0.5 would convert to 0.5 hours.

SGIII showed you how to use date&time and duration values. The numbers in your table such as 7.30, 15.45, etc. are not times of day or durations, they are decimal numbers. 7.30 does not mean 7 hours and 30 minutes, it means the integer 7 plus the decimal 30/100. Because they are not times of day or durations, using them in functions that operate on times of day or durations will give errors.

"I have … set date too 05/01/21, time 19.08 "

                                                                   ^

You should 'set date to 05/01/21, time 19:08 '

Regards,

Barry