Hours and minutes

[Detectiveclem]

Can any help me?

I am trying to finalise a time sheet.
All the cells I am referring to have been custom formulated as[h]:mm
At Cell S13 Ihave a formula which shows the total number of hours and minutes worked over aone week (7 day period).
In Cell P2 I havethe fixed value of 36:00. Thisrepresents the total hours expected to be worked over the week.
And only If cell S13 has any value greater than 0 then Iwant to show in cell T13 only thosehours and minutes either as a minus if less than 36:00 or a plus if greaterthan 36:00.

For example if Cell S13 is blank or contains 0:00 then Iwant T14 to remain blank.
E.G. If Cell S13 has a total of 23:30 I want Cell T13 toshow as (minus) -12:30
E.G. If Cell S13 has a total of 45:15 then I want cell T13to show as 9:15
And finally if C13 has a total of 36:00 then T13 should show0:00 or blank.
Any help would be greatly appreciated.

 

[Detectiveclem]

Re: Hours and minutes question

Hi Wayne, more than happy to do this, if I am not breaching any of the Forum's rules.

I use Dropbox, but not sure how I would be able to invite you to join a shared folder? If you tell me how to do it I will share the spreadsheet that way. I have no reason to keep it private as it is merely a blank time sheet at the moment.

Thank you Paul

 

[etaf]

Re: Hours and minutes question

its not a preferred way on the forum, using one of the special tools to post is preferred , but i cant get them to work on my mac - worked in past on windows 10 - still looking at that
its because the forum would lose the info when you delete the file in the future - so i also try to put in words what the solution is
anyway

you should be able to get a share link from dropbox which you can post the link here