Time functions
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Hi,
I have to do some time calculations and I have a formula that outputs
in minutes and I have to subtract a standard time to this number of
minutes. For example, I have 8:00 AM in one cell and 20.68 minutes on
an other cell. The output that I am expecting is 7:39 AM. Does anybody
know how to bring an output like that by subtracting the minutes?
Please help. Thanks
.
Relevant Pages
- Re: Time functions
... Rick (MVP - Excel) ... I have to do some time calculations and I have a formula that outputs ... in minutes and I have to subtract a standard time to this number of ... I have 8:00 AM in one cell and 20.68 minutes on ...
(microsoft.public.excel) - Re: negative time
... You can just subtract one cell from the other. ... One workbook was using a base year of 1900 and the other was using 1904. ... If a project has a standard time and it is completed in ...
(microsoft.public.excel.misc) - RE: Time functions
... I have to do some time calculations and I have a formula that outputs ... I have to subtract a standard time to this number of ... I have 8:00 AM in one cell and 20.68 minutes on ...
(microsoft.public.excel.worksheet.functions) - Time functions
... I have to do some time calculations and I have a formula that outputs ... I have to subtract a standard time to this number of ... I have 8:00 AM in one cell and 20.68 minutes on ...
(microsoft.public.excel.worksheet.functions) - RE: Desperately needing furmula help
... "Toppers" wrote: ... You could assign this value to a cell and replace the 9 with cell ... "galimi" wrote: ... Subtract the difference and you have the portion you want to ...
(microsoft.public.excel.misc) |
|
