Re: Time functions

Tech-Archive recommends: Speed Up your PC by fixing your registry

Assuming your time is in A1 and your minutes are in A2...

=A1-A2/1440

--
Rick (MVP - Excel)


"Harish" <mahadevan.swamy@xxxxxxxxx> wrote in message news:655b72f9-dcd6-41e9-85c6-127b34e678f9@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Function returning unexpected value
    ... subtract "baseline planned date", presumably the part of the IFexpression ... Indeed, if the cell containing "actual completion date" is empty, which is ... Excel provides some tools for debugging formulas. ... Alan Moseley IT Consultancy ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Dates changed on Copy Cell
    ... Copy the contents by selecting the cell and pressing CTRL+C. ... On the Home tab, in the Clipboard group, click Paste, click Paste Special, select Add (or Subtract depending on which workbook you are pasting to), and then click OK. ... This is an Excel setting, ...
    (microsoft.public.excel)
  • Re: Need formula to subtract 5hrs from date/time field
    ... You just need to remember that times are stored internally in Excel as ... to subtract 5/24 from the time. ... assuming your date/times are in Excel format. ... Another way is to enter this in a blank cell somewhere: ...
    (microsoft.public.excel.misc)
  • Re: format MM:SS without mm/dd/yyyy/hh:mm:ss?
    ... > Is there any way to get Excel to recognize the mm:ss without having to ... plain numbers from one cell and subtract them from another cell and output ... 1230 and subtract it from 1400 to give and answer of 90... ... day/date to get *just* the times,anymore, even in a hh:mm format. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: >> Need help with a simple formula
    ... do it in Excel. ... I need to take the value of a cell. ... value of that and subtract 2.9% from it. ... later calculation in the formula bar). ...
    (microsoft.public.excel.worksheet.functions)