corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Guru's


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel Guru's
Dom
Member

Registered: 13th Sep 03
User status: Offline
4th Mar 08 at 09:06   View User's Profile U2U Member Reply With Quote

Currently have an Excel Timesheet (Date, Time in, Time Out, Overtime worked) but the code i have to work out the overtime is a little basic and causes errors if i worked under my 8 hr day.

code:

Current formula -

=IF((OR(C6="",D6="")),TIME(0,0,0),((D6-C6)-TIME(8,0,0)))



Does anyone know a formula that would calculate overtime as well as 'undertime'? ie: if i work 20 minutes over it would display 00:20, if i worked 20 minutes under it would display -00:20?

Also, is there a formula that could sum up the overtime column (whether it's overtime or 'undertime') that would display the current amount of overtime i have? (again could display 00:00 or -00:00)

cheers all

[Edited on 04-03-2008 by Dom]
Daniel_Corsa
Premium Member

Avatar

Registered: 21st Apr 04
Location: Wigton, Cumbria
User status: Offline
4th Mar 08 at 09:56   View Garage View User's Profile U2U Member Reply With Quote

I'l be able to get you one soon, send me an e-mail over U2U and i'l forward it on!


April '06' Corsasport Feature Car | Aug '08' Total Vauxhall Feature Car | Spring '09' Fast Car Feature Car
Daniel_Corsa
Premium Member

Avatar

Registered: 21st Apr 04
Location: Wigton, Cumbria
User status: Offline
4th Mar 08 at 12:16   View Garage View User's Profile U2U Member Reply With Quote

Sent it via e-mail Dom




April '06' Corsasport Feature Car | Aug '08' Total Vauxhall Feature Car | Spring '09' Fast Car Feature Car

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
Help needed again ...Trotty can you help Red_Corsa Geek Day 17 1679
21st Mar 03 at 00:15
by Red_Corsa
 
Any MS Excel experts Steve Geek Day 11 1300
4th Jun 04 at 14:19
by blebo
 
is there a program that...... chris_uk Geek Day 6 1905
16th Jun 05 at 00:47
by Dan B
 
MS Excel question --Dave-- Geek Day 15 327
16th Aug 06 at 12:59
by Shelly
 
Excel Help AndyKent Geek Day 3 1461
6th Oct 07 at 10:22
by aPk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Guru's 30 database queries in 0.0085518 seconds