Excel/Time formulas

Amir wrote at 2006-08-11 21:36:06
A1 is time you start

B1 is time you quit

C1 is total hours you work.

Format A1 and B1 to HH:MM

Format C1 into Number - Standard

In cell C1 use this formula:

=(B1-A1)*24

Example:

A1= 01:00

B1= 02:15

=(02:15-01:00)*24

In cell C1 you would get 1,25

doug wrote at 2007-08-28 00:01:29
use this formula and adjust the cell references for what you need.

=IF(((HOUR(M3)+(MINUTE(M3)/60))-(HOUR(K3)+(MINUTE(K3)/60)))>=8,((HOUR(M3)+(MINUTE(M3)/60))-(HOUR(K3)+(MINUTE(K3)/60)))-0.5,((HOUR(M3)+(MINUTE(M3)/60))-(HOUR(K3)+(MINUTE(K3)/60))))

Michael wrote at 2008-06-02 17:55:03
The formula to calculate simple times in whatever format 24/12hr. (8 am - 4:30pm) is:

=(endtime-starttime-TIME(0,0,0))*24 will give you the hours worked in decimals.

in the next column use a formula

=(result-0.5)*rate of pay.

eg. a1=8 am, b1=4:30 pm

c1=(b1-a1-time(0,0,0))*24 = 8.5

d1=(c1-0.5)*12(for twelve bucks an hour)

=96\$ formatted(\$)

Stacee wrote at 2009-06-08 20:10:00
This will answer your question completely.  Use the formula =24*(IF(A1>B1,B1+1-A1,B1-A1)).  That will give you the 4.5 that you are looking for.

Vicky wrote at 2012-04-12 15:36:14
Hello people,

It is so simple Just say if you are subtracting some X of time from the time you have , then the formula for it is

=Field Name(A5)- TIME(1,35,10)........

Were A is the Field Name ,In the Bracket it represents Hours, Minutes, seconds.

MotherJame wrote at 2013-10-02 04:49:44
I use =(B1-A1)*24 number format to 2 decimal places.  I hope this helps.