Time Calculations
Date: Wed, 19 Jan 2005 20:13:04 -0800
I need a calculation to subtract the start time from the finish time when the
time is in the format of hours:minutes such as Start time as 1:40,
Finish time as 3:10 with the difference being 90 minutes?
--
thanks,
askgail
Relevant Pages
- Re: Find in a date range
... The equivalent Script would then be something like: ... Assuming you mean a calendar month the calculation part of the Set ... Field above has to work out the current month and subtract 1. ... Captain) instead of a year month day or day month year format. ... (comp.databases.filemaker) - Re: Measure between date time A to date time B
... Subtract the later from the earlier and format the result as either ... calculation. ... Stewart:) ... (microsoft.public.excel.misc) - Re: Form Protection with Excel Object Embedded
... the best field to base the calculation on might be the one in the example titled 'Calculate the # Days Difference ... The date input format is of no consequence, provided both dates have a day, month and year- you might want to enforce this via the ... Excel workbook, though. ... At most, you'll need to insert a paragraph break immediately before the workbook, then format the workbook ... (microsoft.public.word.application.errors) - RE: Phone number query in query form
... this is to create a calculated field in the query ... messagio e provero di spiegarmi meglio. ... form of calculation with the data or sort it in some calculated ... When I type the value, in the mentioned format, in the query I get the data, ... (microsoft.public.access.forms) - Re: Form Protection with Excel Object Embedded
... the best field to base the calculation on might be the one in the example titled 'Calculate the # Days Difference ... The date input format is of no consequence, provided both dates have a day, month and year- you might want to enforce this via the ... If you prefer to retain your Excel workbook, though, insert Section breaks either side of it and leave that Section unprotected ... Is there a way to do it without unprotecting the line? ... (microsoft.public.word.application.errors) |
|