time diff computation

[erlindafb]

hello again,


pls help me to solve, that


working time is 9am,

reported at 10:45am, subtracting the two, 1 hour and 45 minutes late, how can i put a formula into it, and formula also for reporting earlier.


-tried this formula IF(9am>(10:45am),HOUR(C38),minutes(C38)) but it was an #name appears.


thank you so much!!!

 

[majay1973]

Hi erlindafb,


considering Working time is in column C, Reported Time is in column D and the difference is calculated in column E,

then use this formula in E column..

=IF(C6>D6,(C6-D6),(D6-C6))

 

[sdsurzh]

Hi,


Assume your data

A3=09:00:00

A4 =10:45:00


A5=IF(A3<A4,A4-A3," ")


(It will show blank when people are came in time or before and it will calculate only if any one came late)


Thanks,

Suresh Kumar S

 

[erlindafb]

thanks you so much to both of you....