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?
Views
Replies
Total Likes
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.
Views
Replies
Total Likes