Expand my Community achievements bar.

Calculation formate

Avatar

Level 1

I have created an absence form for our department...each day represents 7 hours...however when I enter the .5 days it just reads it as so...how can I come up with a calculation which will represent lets say 5.5 days...the way i have it now it says 35.5 hours which in fact it should say 38.5 hrs...if anyone could help me incorcorate the right formula into my calculation it would be great!

I'm sure there is a way to insert something which would render the .5 into a 3.5 hrs?

1 Reply

Avatar

Level 6

if ur entering days in one field

on total hours display field calculation event script is: Totaldaysfieldname * 7;

if ur using one field for each day

on total hours display field calculation event script is: (day1fieldname.rawValue + day1fieldname.rawValue + day3fieldname.rawValue...)* 7;

i am unable to attache sample form here.

if ur still having the problem in ur form, can u post the pdf?

RAGHU.