Converting formula

[RPT_22]

Hi,
I am using a table and need help in converting a formula into minutes
formula =[@[FINISH TIME]]-[@[STARTING TIME]]
Cell I2[FINISH TIME = 10:50:00] - Cell F2 [STARTING TIME = 9:05:00] = K2 [TOTAL TIME 1:45:00]
1. What formula would i use in the table to convert actual time difference into minutes Cell I2-F2=K2
2. What formula would i then use to create a cost value in M2 [ minutes in K2 * $95.00 per hour]

Thank you

 

[Alex Blakenburg]

Excel stores Date-Time as a number in days. Time is the decimal portion of the number.
So to get the result in minutes:

=( [@[FINISH TIME]]-[@[STARTING TIME]] ) * 24 * 60

(or a straight * 1440 )

Edited:
Your M2 formula is using K2 in minutes so you would need to convert the minutes back to hours and ideally apply some rounding.

=K2 / 60 * 95.00

 

[myall_blues]

Times in Excel are formatted but underneath they represent the portion of a day, so if you format 1:45:00 as general you will find it has a value of 0.0729167. To convert that to minutes multiply the value in K2 by 1440 (which is the number of minutes in a day).
K2=(I2-F2)*1440 (and format as general or number)
M2=K2*95/60

Book1
	E	F	G	H	I	J	K	L	M	N
1
2		9:05:00			10:50:00		105		166.25
3
4
Sheet1

Cell Formulas
Range	Formula
K2	K2	=(I2-F2)*1440
M2	M2	=K2*95/60