Use the ADDMIN function - along with it's SEC & HR counterparts and equivalents for dates one of my most used functions but which seem to be the least known about.
You can also use a negative "addition" to subtract as well - if you see what I mean. Regards, Alastair. On 31/01/2017 00:37, Tom Hart wrote: Is there a way to convert and integer/real to time. Here is what I want to do I want to calculate waiting time for customers, so if I know the waiting time for each customer is 20 min and the 5th customer wants to know how long the wait I can get to the wait is 100 min but how can I convert to a time so it would show 1 hr 40 min Tom Hart -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
