hi,,,,,
pls. help me how to calculate time difference in excel sheet suppose i have to calculate the diff between
10:00 to 10:40 then??????
10:00 to 11:40 then ?????
i want the diff. in minutes onlyyyyyyy
plzzzzzzzzzzzzz
2 Replies
subasri
(searching for a job)
(54 Points)
Replied 20 December 2009
Type the times in two different cells.now in another cell type the formula =minute(first cell reference-second cell reference).you will get the answer in minutes.but this formula gives you the answer only if the difference is within 60 .if it exceeds 60,then the formula is =(first cell reference-second cell reference).
example:
B4=10:40
C4=10:00
then the formula is =minute(B4-C4),the ans is 40
if B4=11:40
C4 is =10:00
then the formula is =(B4-C4)*1440,the ans is 100.
subasri
(searching for a job)
(54 Points)
Replied 20 December 2009
if B4 =10:40,C4=10:00,the formula is =minute(B4-C4),the ans is 40.(this formula is used if the difference is within 60 minutes)
if B4=11:40,C4=10:00,the formula is =(B4-C4)*1440,the ans is 100(this formula is used if the difference is more than 60)
Recent Topics
- Share office desk in bkc, near family court
- 80D claim for payment paid by parent
- TDS on purchase of Flat under subvention scheme be
- Nznxnc call me at the end of the day of the
- Nsje snswk fjw ed le ene djff ne enje ejdd rejje
- Hxjcif the day I have been in touch with me and
- Iska djd djrbdsjebshe sir ur rei ejr reinr the jr
- GST registration for medical shop in Karnataka
- Hsshs me know if you are free number of the
- Chu Kang and the situation of the situation and I
Related Threads
CAclubindia
