# New & need help on formulas for calculating time, time 1/2 & double time for payroll

1. ## New & need help on formulas for calculating time, time 1/2 & double time for payroll

Hi - First ever forum & consequently first ever post! So please be kind I need help on calculating a formula that works backwards from total hours worked daily. First 7.2 hours are regular pay, next 2 hours are time and a half anything following this is double time. I don't need the calculation of pay rates - just the hour totals. However if working under 7.2 hours (or not at all) it has to reflect accordingly. I have been able to get the formulas for the regular & double time - but not the tricky 2 hours in the middle. =MIN(\$B\$11,Sheet1!B3) this formula works for the regular =MAX(0,B5-2) and this works for double time (anything after 7.2 + 2). Any help would be greatly appreciated, as my brain is frazzled at the moment

2. ## Re: New & need help on formulas for calculating time, time 1/2 & double time for payroll

Hi Angie,

Welcome to the forum!

I've attached a workbook for you, and hopefully, this is what you are looking for. If not, let me know.

Don't forget to click the little star to the left of this post if you feel I helped!

3. ## Re: New & need help on formulas for calculating time, time 1/2 & double time for payroll

Thank you TheExcelphile! Saved me a lot of thinking, especially as I don't know excel formulas that well. Excuse my ignorance , but I can't find the star to click on the left (you have helped and answered my question perfectly)!

4. ## Re: New & need help on formulas for calculating time, time 1/2 & double time for payroll

Found it (sorry just had to look harder!)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.05922 seconds
• Memory Usage 8,894KB
• Queries Executed 15 (?)
Template Usage (32):
• (1)footer
• (1)forumrules
• (1)gobutton
• (4)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (1)postbit_attachment
• (4)postbit_legacy
• (4)postbit_onlinestatus
• (4)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php
• ./includes/functions_notice.php

Hooks Called (47):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• postbit_attachment
• tag_fetchbit_complete
• forumrules