Overview

Hello I have the following formula for a calculated column in a custom SharePoint Online list that calculates the total hours worked between 2 times and then deducting 30 minutes for lunch. =(IF([start Day & Time]="",0,([Finish Day & Time]-[start Day & Time]-"00:30")))*24 This formula works a treat and calculates the total hours worked. I now want it to deduct 30 mins from the total hours if those hours total more than 6. I have the tried this (which is the formula in my original spreadsheet), =(Finish time-Start time)*24-IF((Finish time-Start time)*24>=6, 0.5, 0) but I'm struggling to adapt it to work in SharePoint online. Any help would be greatly appreciated. Many thanks in advance

thanks for that info. I've just had a scoot around the website and will give them a ring.

have a look at Combined Knowledge - they do great SharePoint 2007 and 2010 training courses. I can give you a quote as well which might help on price (I'm an authorised reseller of theres). Get in touch if needed or speak to Zoe at CK

has anyone come across any good Sharepoint 2007 training providers for those in an Administrator role and for those looking to move to a Developer role?

School Portal Gets a New Facelift | Nota Bene George Washington University Law School uses SharePoint for both their Public Website and Intranet/Extranet/Portal

we are using moss 2007 and moodle for our learning gateway

We use Sharepoint as our Learning Platform.

Has anyone gone down this route? I am currently using Sharepoint for the Intranet and will hopefully be adding SharepointLMS to it, to make it a fully functional VLE. Matt