Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time calcualtion in minutes
Excel 2007
Working with an .xls template used as a timesheet. Three columns time started, time finished and time taken. Can Time Taken be shown as minutes? We can subtract end from start time and get to see it as hh:mm but can't get just mm as the correct total number of minutes. eg if 9:30 to 11:00 is 1 1/5 hours, can we see a total as 90 minutes somehow? JudyG |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time calcualtion in minutes
Judy,
Format the cell as custom with the format [mm]:ss HTH, Bernie MS Excel MVP "Judy Gleeson" wrote in message ... Excel 2007 Working with an .xls template used as a timesheet. Three columns time started, time finished and time taken. Can Time Taken be shown as minutes? We can subtract end from start time and get to see it as hh:mm but can't get just mm as the correct total number of minutes. eg if 9:30 to 11:00 is 1 1/5 hours, can we see a total as 90 minutes somehow? JudyG |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time calcualtion in minutes
If your 9:30 and 11:00 are in A1 and B1 respectively, =B1-A1 will show 1:30
(1 1/2 hours, not 1 1/5), and =(B1-A1)*24*60 (if you format as general or number) will show 90. If you just format the =B1-A1 as [m] it would show as 90, but the number in the cell would still be 90/(24*60) as Excel stores times as fractions of a day. -- David Biddulph "Judy Gleeson" wrote in message ... Excel 2007 Working with an .xls template used as a timesheet. Three columns time started, time finished and time taken. Can Time Taken be shown as minutes? We can subtract end from start time and get to see it as hh:mm but can't get just mm as the correct total number of minutes. eg if 9:30 to 11:00 is 1 1/5 hours, can we see a total as 90 minutes somehow? JudyG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
Calcualtion of renewal | Excel Worksheet Functions | |||
Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) |