Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time functions
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time functions
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) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Harish" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time functions
But this doesn't give me 7:39 AM as in exact format.
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time functions
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. -- Rick (MVP - Excel) "Harish" wrote in message ... But this doesn't give me 7:39 AM as in exact format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time functions | Excel Worksheet Functions | |||
time functions | New Users to Excel | |||
Calculating time without using time functions... | Excel Worksheet Functions | |||
Time functions | Excel Discussion (Misc queries) | |||
Time Functions | Excel Worksheet Functions |