Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I calculate minutes when given two times?
I have a spreadsheet that contains one set of cells that is time in and
another set of cells that is time out. I have been able to calculate elapsed time in hours and minutes by converting the time in and time out to military time. Excel is reading this as a time of day rather than the length of time. How do I convert the elapsed time into minutes so that I can measure averages |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I calculate minutes when given two times?
If you have time in this format hh:mm you can convert it to minutes by
multiplying with 1440 and format it as General (don't forget to change the format) -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Kina" wrote in message ... I have a spreadsheet that contains one set of cells that is time in and another set of cells that is time out. I have been able to calculate elapsed time in hours and minutes by converting the time in and time out to military time. Excel is reading this as a time of day rather than the length of time. How do I convert the elapsed time into minutes so that I can measure averages |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I calculate minutes when given two times?
Try this Enter 8:30 in cell a1 enter 14:45 in cell a2 The elapsed time in minutes is =HOUR(A2-A1)*60+MINUTE(A2-A1) Matt -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=552876 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I calculate times in seconds and minutes using percentages | Excel Worksheet Functions | |||
Calculate with codes and times | Excel Worksheet Functions | |||
calculate elapsed time between dates and times | Excel Worksheet Functions | |||
how do i calculate minutes between two times? | Excel Discussion (Misc queries) | |||
How do I convert times from hours to minutes? | Excel Discussion (Misc queries) |