Formular format help??

Hi all,

Need some help with two formulars that I use for time sheets on Openoffice. I would like to run the same spreadsheet on my iphone using numbers for ease but I dont know how to format it so numbers can understand all the characters??

I need to use these....

=IF((((F3-C3)-(E3+D3))*24)>8;8;((F3-C3)-(E3+D3))*24)

=IF(((F3-C3)-(E3+D3))*24>8;((F3-C3)-E3+D3))*24-8;0)

What do you replace the semi-colon with?

Whatever I've tried so far Numbers doesn't recognise??!

Thanks in advance,

Regards,

Paul.

iOS 5.1

Posted on Apr 11, 2012 12:49 PM

16 replies

Apr 22, 2012 3:07 PM in response to KOENIG Yvan

Yvan,

I didn't forget. I said "US English", where I know that the period is used.

I should give the alternate syntax just in case...

Here are the semicolon-delimited equations:

Straight Hours:

=IFERROR(MIN(E-B-(C+D): "8h"); "")

Overtime Hours:

=IFERROR(E-B-(C+D)-F; "")

Total:

=IFERROR(F2+G2; "")

The last expression doesn't require a delimiter

By the way, I don't know where the SUM came from in my day's hour total expression in the first post. It must have been left over from the original and I apparently overlooked it in the cleanup. That should have been:

=IFERROR(F2+G2, "")

Jerry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Formular format help??