Time functions

[Harish]

Hi,
I have to do some time calculations and I have a formula that outputs
in minutes. 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

 

[Luke M]

Assuming 8:00 AM is in cell A2, and 20.68 is in A3
=A2-A3/1440

The 1440 converts your number into minutes (1440 = 24 hrs * 60 minutes)

 

[Harish]

But this doesn't give me 7:39 AM as in exact format.

 

[Rick Rothstein]

A common problem with times... Excel is guessing at the format (it thinks
you want a full date so it gives you the date corresponding to a serial
number of zero along with the time value)... just format the cell the way
you want it to look.