Schema2 and time calculations
William Jackson
I'm using Scema2 version 1,21 (04-Aug-2006) and I'm trying to add together
hours worked during a week to give me total hours in the format HH hrs:MM
mins.
I.e. if the hours worked for each of these days of the week were
7:30,3:20,7:15,8:05,7:25,6:10 the total for the week should look like this
39hr(s):45min(s). That is I want the spreadsheet to calculate in base 60.
What is happening is that it reaches 24 hours it then starts from 1 again if
the format is %24:%mi which isn't what I'm after.
If I use the functions Time and TTime that returns the year/month/day/hour/
minute/second again not what I'm after unless there's a way of suppressing
the year/month/day and seconds and calculating beyond 24 hours.
I've not seen anything in the manual which explains how to do it, unless
I've not understood it properly.
More generally is there a way of selecting various bases(?) in Schema2 i.e
12(feet and inches) 16(lbs and ozs) 14(stones and lbs) etc.
Many thanks for the advice
William
--
/ \._._ |_ _ _ /' Orpheus Internet Services
\_/| |_)| |(/_|_|_> / 'Internet for Everyone'
_______ | ___________./ http://www.orpheusinternet.co.uk
Robin Hounsome
> I'm using Scema2 version 1,21 (04-Aug-2006) and I'm trying to add
> together hours worked during a week to give me total hours in the format
> HH hrs:MM mins.
> I.e. if the hours worked for each of these days of the week were
> 7:30,3:20,7:15,8:05,7:25,6:10 the total for the week should look like
> this 39hr(s):45min(s). That is I want the spreadsheet to calculate in
> base 60.
> What is happening is that it reaches 24 hours it then starts from 1
> again if the format is %24:%mi which isn't what I'm after.
I don't use Schema, but in Eureka I use the following, which you may be
able to adapt.
This splits the hours and minutes across two cells
Enter this formula in to the cell to contain the hours
=INT(the cell which contains your total time*24).
Enter this into the cell to contain the minutes
=MINUTES(the cell which contains your total time)
HTH
Robin
--
Remote - http://www.hounsome.org.uk
TV display software for the Iyonix
William Jackson
I have found a Schema2 Macro by Dave Floyd which adds a column of times and
outputs it in terms of hours and minutes. I think that just needs to be
adapted that to add a row of times. Since I'm not a programmer any help
here would be appreciated.
Many thanks
william