Help me find how to input the difference in time please.

[bksparkz]

This is my first post and I am in need of some help on my excel project.

In (F4) I have 6:05 inputted in there.
In (G4) I need it to tell me the total time exceeded over 30 minutes (and to be in red).
Basically I need (G4) to read (5:35 (in red))

What formula do I use?

Thanks everyone!

 

[ITWare2008]

Hi bksparkz,

Welcome to the board.

The fastest way is place 0:30 in B1 for instance and at c1 write this formula

=a1-b1

Assuming you have your time at a1

Hope this help.

Vândalo

 

[Rick Rothstein]

This is my first post and I am in need of some help on my excel project.

In (F4) I have 6:05 inputted in there.
In (G4) I need it to tell me the total time exceeded over 30 minutes (and to be in red).
Basically I need (G4) to read (5:35 (in red))

What formula do I use?

Give this formula a try...

=IF(F4>TIME(0,30,0),F4-TIME(0,30,0),"")

and use Format Cells to make the display a Time format displaying only hours and minutes and make the cell's font red in color.

 

[bksparkz]

Thank You.
That formula worked.
I really appreciate everyones help.