Can somebody please check my math (1 Viewer)

Dreamweaver · Nov 9, 2018

I have an invoive that in this instange totals all the booked hrs and mins into one entry for the day see attached image

the cost is per hr and QT if the hrs and mins total booked for that day the total is what the client will be charged for that day

I may be going mad but it don't seem right so if somebody could give it a check i would really appreciate it.

Ranman256 · Nov 9, 2018

its possible you arent seeing the entire number.
it could be 4.0154521
the cell just rounds to 4.02 as a display.

check that.

isladogs · Nov 9, 2018

If 3.45 actually means 3hr 45min (3.75hr), the answer is correct.
Similarly with the others I expect.
Otherwise it's nonsense

Dreamweaver · Nov 9, 2018

I will have to check the code to see if i round it at all but built the program years ago just updating it thanks for taking a look

Dreamweaver · Nov 9, 2018

isladogs said:
If 3.45 actually means 3hr 45min (3.75hr), the answer is correct.
Similarly with the others I expect.
Otherwise it's nonsense

thanks you are correct i can stop sweating now lol

Gasman · Nov 9, 2018

Well spotted Colin, that would be very confusing to me.

I have used that format myself, but for me it meant 3 decimal 45 hours. (3 hours 27 minutes).

Dreamweaver · Nov 9, 2018

Gasman said:
Well spotted Colin, that would be very confusing to me.
I have used that format myself, but for me it meant 3 decimal 45 hours. (3 hours 27 minutes).

Thats on the list to be reformated so it reads 3:45 never had any complaints in 10 years but I feel the same.

isladogs · Nov 9, 2018

Another forum thread a couple of months ago had exactly the same issue so it was the first thing I checked. It was obviously not rounding error

Personally I would use 03:45 to denote hours & minutes or 3.75 to denote parts of an hour as its only too easy to get confused

Dreamweaver · Nov 9, 2018

Trouble I'm having is the invoicing system has to invoice per item or hours some invoices would include time on developing and additional full programs or other charges like training etc

Can somebody please check my math (1 Viewer)

Dreamweaver

Well-known member

Attachments

Ranman256

Well-known member

isladogs

MVP / VIP

Dreamweaver

Well-known member

Dreamweaver

Well-known member

Gasman

Enthusiastic Amateur

Dreamweaver

Well-known member

isladogs

MVP / VIP

Dreamweaver

Well-known member

Similar threads

Users who are viewing this thread