How do I write a formula that will calculate negative time values, i.e., 5:00 - 4:55 = -5 ?
G General Patton Oct 1, 2009 #1 How do I write a formula that will calculate negative time values, i.e., 5:00 - 4:55 = -5 ?
L Luke M Oct 1, 2009 #2 You coudl *cheat* and display the number as a regular number, and manipulate the number to properly display minutes. Setting the cell format to number, you could use this formula: =("4:55"-"5:00")*1440
You coudl *cheat* and display the number as a regular number, and manipulate the number to properly display minutes. Setting the cell format to number, you could use this formula: =("4:55"-"5:00")*1440
G General Patton Oct 1, 2009 #3 That worked Luke! Thank you for your help. Luke M said: You coudl *cheat* and display the number as a regular number, and manipulate the number to properly display minutes. Setting the cell format to number, you could use this formula: =("4:55"-"5:00")*1440 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* Click to expand...
That worked Luke! Thank you for your help. Luke M said: You coudl *cheat* and display the number as a regular number, and manipulate the number to properly display minutes. Setting the cell format to number, you could use this formula: =("4:55"-"5:00")*1440 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* Click to expand...
